PDA

View Full Version : Phone number format


jody wyttenbach
Jan 31, 2008, 12:04 PM
I need to change the format of phone numbers in excel from the standard 000-000-0000 to #10000000000.

litelegs
Jan 31, 2008, 06:39 PM
I think if you just go to format-cell and click on the "general" under category the number will appear as 4548675309. Is that what you were looking for?

JBeaucaire
Feb 1, 2008, 02:41 AM
If your example is EXACTLY what you want, the #1 added to the beginning of a typed in 10 digit telephone number, do this:

Highlight the cells
FORMAT > CELLS > NUMBER > CUSTOM
in the TYPE box, enter: "#1"0000000000
Select FORMAT > CONDITIONAL FORMATTING
Cell Value is / less than / 999999999 (that's nine nines)
Click on FORMAT and set the color to RED
Try it out now. If you enter a perfect 10 digit number it will add the #1 to the beginning. But if you do not enter enough digits, the data will appear in RED and you know you need ot fix it.