| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I format telephone numbers?
I have somehow messed up my tel numbers.. idiot!
Previously 011 740 1342, 082 443 0707 and 09 64 456 8799 in different cells. Now 117401342, 824430707 and 9644568799. Cells are formatted as "numbers, 0 decimals" Lost the preceding zeros and the spaces. Formatting as "text" does not help. Other than doing each cell manually (I have over 200 names), is there a way to get back to what I had before. The file has been saved - I cannot "undo"...clot! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Format Telephone Cell Range | Excel Worksheet Functions | |||
| Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
| Numbers aren't changing with new format why? | Excel Discussion (Misc queries) | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
Threaded Mode
