My message told you how to reopen it in Excel without losing the trailing
zeros. [If you open the csv with Notepad you'll see that the trailing zeros
aren't lost in the saving operation, so they are still there in the text in
the csv file.]
No, there isn't a setting you can change. If you save as txt rather than
csv, then you'll always get the opportunity to set the options for each
column rather than Excel making its own decisions.
--
David Biddulph

hgarrison wrote:
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?