Preserving "trailing" zeros from csv file

[hgarrison]

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?

 

[AnotherNewGuy]

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]

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.

 

[Fred Smith]

The only way to preserve zeros after the decimal point is to convert the
number to text before saving the CSV.

Regards,
Fred