View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sergio
 
Posts: n/a
Default data truncates when converting .csv to .xls

I receive every day an e-mail with a file with data in .csv format.
When opening this file as a .xls, a specific field with a 20 digit value,
gets truncated and last 5 digits appear as Cero.
(of course they were not Cero in the original .csv file)
in summary:
"23848730987391234598" is converted to -- "23848730987391200000"

can someone help?
than you