Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do in input phone numbers starting with 0 into excel
i tried to input mobile phone numbers into an excel spreadsheet but the 0 at
the beginning always disappears. Does anyone know how to rectify this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do in input phone numbers starting with 0 into excel
Try formatting the cell and changing it to a text format. This will allow
the 0 to remain at the start. If you need help doing this, please just reply. Cheers, Matt "Please Help" wrote: i tried to input mobile phone numbers into an excel spreadsheet but the 0 at the beginning always disappears. Does anyone know how to rectify this problem? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do in input phone numbers starting with 0 into excel
There's a telephone number format that might work. It's based on your OS
regional settings. FormatCellsNumber tabSpecial. If that doesn't work then you can preformat the cell as TEXT or precede the entry with an apostrophe: '020-10-555-1212 Biff "Please Help" <Please wrote in message ... i tried to input mobile phone numbers into an excel spreadsheet but the 0 at the beginning always disappears. Does anyone know how to rectify this problem? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do in input phone numbers starting with 0 into excel
I can give you an expert level answer that absolutely will work. But, I
first need to know if ALL the numbers are exactly 10 digits. -- big-bob "Please Help" wrote: i tried to input mobile phone numbers into an excel spreadsheet but the 0 at the beginning always disappears. Does anyone know how to rectify this problem? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do in input phone numbers starting with 0 into excel
Putting a space anywhere in the phone number will solve the problem if this
is suitable. "Please Help" wrote: i tried to input mobile phone numbers into an excel spreadsheet but the 0 at the beginning always disappears. Does anyone know how to rectify this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to make Excel 2000 dial phone numbers? | Excel Worksheet Functions | |||
FedEx tracking numbers in Excel | Excel Discussion (Misc queries) | |||
how to use excel to track phone numbers | New Users to Excel | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions |