Software

Ask something
Question Locked

Saving telephone numbers in Excel csv format

0 helpful
2 replies

by richard.hodgson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to import a data file into an application using excel csv. One field contains UK telephone numbers with leading zeros.

These 0's are being dropped off when I save excel as a csv file and then re-open.

How can I retain the leading zero?

2 replies

by pshiflet-24

There should be a text signifier that you can append to the beginning of the numbers. Usually it is an apostrophe but it is changeable depending on the import process you are using.

Let me know if this helps or you have further questions. Thanks.

This discussion is closed to new replies.