displaying a zero in phone numbers

S

stosh

everytime i type a phone number in a cell the zero dissapears, how do i stop
this from happening.
many thanks in advance
 
B

beege

Mike H is right.

Phone numbers aren't really numbers, as you'll never perform
calculations on them. Same with Zip Codes. Treat them as text, with
either an apostrophe, or format the cells as text.

Beege
 
B

Brad

Another way is to do a custom format

either 000-0000
or (000) 000-0000

One way to find custom format is right click (the mouse) on a cell go to
format cell -number format - custom
 
Top