Preserving "trailing" zeros from csv file
After opening, you can just format the columns with numbers and dates if you
want. You'll lose that formatting, though, if you save the file as a CSV
again.
"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?
|