Hi Dave,

Have just done a test and your spot on the 0 values are there when opened in
note pad. However i need to get the csv file into excel to do some coverting
on the actual data. Any thoughts??

"Dave Peterson" wrote:

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