Maybe the 0's didn't get dropped.

If you save the file as a .CSV and then use NotePad to look at the data, do you
see the 0's?

(You will lose them if you open that .csv file in excel.)

mike wrote:

Hi All,

Does any one know of a clever way to save an excel file as a csv file with
out dropping 0 values.

For example i have several columns of data one being a product code. A
product code is 0145 and i need all four digits to be saved to import into
our accounts software (Exchequer)

Many thanks in advance for any help.

--

Dave Peterson