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!
|