Display leading zeros

  • Thread starter Thread starter Gerd
  • Start date Start date
G

Gerd

I extract some data from a POS and create a .csv file. One field is an item
number which can have 1 or multiple leading zeros (from the barcode). The
..csv file shows the leading zeros correctly when I load it into a text
editor but when I load it into Excel (2003) the leading zeros are not
displayed. However, because I need to load the Excel into Quickbooks I need
to retain the leading zeros.

I checked the options and also the help file but did not find anything I
could do to show the leading zeros in Excel.

Any comment/help is greatly appreciated.
 
Hi Gerd,

I suppose the number of digits is fixed?
Format>Cells>Number>Custom
In the Type box, enter 00000000
Or as many zeros as you require digits to see
 
You could give that field a custom format (format|cells|number tab) and tell it
how many 0's to keep with a custom format of:

000000
(for 6 digits).

You could rename the .csv file to .txt. Then File|open the .txt file.

You'll see a wizard pop up and you can specify that you want that field brought
in as text.
 
Back
Top