csv format drops ending zeros

[Excel 2007 - CSV format]

I'm saving an excel file into a csv format and its dropping the zeros at the
end of the numbers.

 

[Gary''s Student]

Use the Import Wizard:

Data > Get external data > from text file

and specify your .csv

You will be able to control the formatting.

 

[David Biddulph]

Look at the CSV with Notepad, and I'd guess that you'll see the leading
zeroes. Your problem will be if you try to open the CSV with Excel, in
which case it will convert the text to numbers and thus lose the leading
zeroes. Instead of Open, use Excel's Data/ Import External Data if you wish
to use Excel to look at the CSV, then you can specify the format of the
relevant columns as text.
--
David Biddulph

"Excel 2007 - CSV format" <Excel 2007 - CSV
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Dave Peterson]

You can also rename the .csv file to .txt and use file|open.

You'll be prompted to give the type of field for each column.

If you choose text, the leading 0's will be kept.

If you want to keep the value as a real number, you'll can keep the .csv (or
..txt) and give the column a nice number format:

format|cells|number tab|Custom category
00000
(for 5 digits)