Preserving "trailing" zeros from csv file
Thanks. When I save the file as .csv, close the file, and reopen it, Excel
still drops the trailing zeros. I'm hoping there is some setting or default
that I can change to prevent Excel from doing this.
"David Biddulph" wrote:
Import the file as text.
Data/ Import External Data (or rename the .csv as .txt and open), and
specify the columns as Text.
--
David Biddulph
hgarrison wrote:
When opeing a csv file in Excel, Excel drops any zero-value decimal
points. E.g. 12500.00 becomes 12500
When I open the file in Word, the zero-value decimal points are there.
I can't find where I can change Excel's settings to prevent this from
happening.
Any ideas?
|