MS Excel Question

Dutch · 03-17-2006, 04:02 PM

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 · 03-17-2006, 05:20 PM

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 · 03-17-2006, 05:35 PM

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

03-17-2006, 05:20 PM	#2
GabeRivers n00b Join Date: Mar 2001 Location: Texas, USA	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.

03-17-2006, 05:35 PM	#3
Dutch "Dutch" Join Date: Oct 2000 Location: Tampa, FL	Great, I'll give that a shot. Thanks!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)