Saving telephone numbers in Excel csv format

By richard.hodgson ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: csv

by christianshiflet In reply to Saving telephone numbers ...

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.

Related Discussions

Related Forums