View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SouthAfricanStan SouthAfricanStan is offline
external usenet poster
 
Posts: 7
Default 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!