View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AnotherNewGuy AnotherNewGuy is offline
external usenet poster
 
Posts: 44
Default 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?