csv files

J

Jake

I'm having trouble converting bar codes with leading zeros into csv files
for use from Excel to Accpac. When files are saved as .csv files in Excel
it doesn't allow the leading zero formatting to be kept. Is there a method
to convert Excel files to .csv files and preserver the leading zeros?
thanks!
 
M

Myrna Larson

If you look at the CSV file in Notepad, you'll see the leading 0's ARE THERE.

If you are trying to check this by opening the file in Excel, what happens is
that Excel drops them. They have to be restored by formatting.
 
D

David Biddulph

Myrna Larson said:
If you look at the CSV file in Notepad, you'll see the leading 0's ARE THERE.

If you are trying to check this by opening the file in Excel, what happens is
that Excel drops them. They have to be restored by formatting.
Click to expand...

.... or if you rename the .csv to .txt, then open that with the wizard and
specify the format of the column as text.
 
Top