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