MS Excel Question

[Dutch]

I have added a phone number to a cell.

'5551234'

I can change the cell format to think it's a phone number and it will look like this '555-1234'.

But when I export that value (into Outlook Contacts), it predictably loses the dash.

How can I convert a formatted cell into a WYSIWYG cell so the dash is actually part of the cell?

Any help is appreciated

[GabeRivers]

Use the text formula, for example: '=TEXT(Cell Loc,"000-0000")', where 'Cell Loc' is the cell where your number is located. I'd then recommend copying and pasting value. If your dealing with a range of cells, in a column for instance, you could create your text formula in the adjacent column, fill down, then select the new column and do the copy paste/value routine.

There may be a better way, but this will do it.

[Dutch]

Great, I'll give that a shot. Thanks!