I have a spread sheet (csv) with *,000s of phone numbers in, currently they are showing without the initial '0'.
I can highlight the column, select format and custom and enter 00000000000 which will add the 0 to the front of the number. however when saved and reopened the 0 disappears again.
even if I save as text afterwards the 0 disappears.
the aim - to permanently add the 0 to the front of the phone numbers.
any help is gratefully received.