Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying a zero in phone numbers
everytime i type a phone number in a cell the zero dissapears, how do i stop
this from happening. many thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying a zero in phone numbers
Hi,
Type an apostrophe ' first Mike "stosh" wrote: everytime i type a phone number in a cell the zero dissapears, how do i stop this from happening. many thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying a zero in phone numbers
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 stosh wrote: everytime i type a phone number in a cell the zero dissapears, how do i stop this from happening. many thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying a zero in phone numbers
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 -- Wag more, bark less "stosh" wrote: everytime i type a phone number in a cell the zero dissapears, how do i stop this from happening. many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
phone numbers | New Users to Excel | |||
Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions |