Thread: Preserving "trailing" zeros from csv file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hgarrison hgarrison is offline
external usenet poster
  
Posts: 2
Default Preserving "trailing" zeros from csv file
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?
Reply With QuoteReply With Quote