Hi Tom,
Sorry to say this didn't work for me it did the same as before, dropping the
@ and the leading zeros, any other ideas? Thanks for helping.
Regards
Kingie

"Tom Hutchins" wrote:

Put a single quote ' at the beginning of every cell containing text (this
includes your numbers with leading zeros). The single quote will be dropped
when the file is exported to .csv format, but the leading zeros will be
retained.

Hope this helps,

Hutch

"kingie" wrote:

nI wish to save a list of numbers that have leading zeros for use as data in
a notepad file. When i change the file from xls to csv it drops off the
leadibg zeros. I have tried formatting everything as text but when you save
to csv it changes the format back to general. Can you help please?There are
two fields in the data base