My mistake, David. I was probably thinking of Lotus which put quotes around
text values, but Excel certainly doesn't. So, as you say, the formatting is
lost on reopen. Thanks for pointing out the error.

Regards,
Fred.

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Which version of Excel behaves that way, Fred?

In Excel 2003, if you have one cell with 123 formatted as a number with 3
decimal places to show 123.000, and another cell with the text value
123.000, when it is saved as a csv they both show as 123.000 in the csv
file. I'm interested to know version you have if it behaves differently.
--
David Biddulph

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

Regards,
Fred

"hgarrison" wrote in message
...
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?