View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
 
Posts: 285
Default numbers truncating

I have exported a file as a .csv file and when I open it in Excel the numbers
truncate ( I think that's what they're doing) ex. 5193571568 chages to
5.195E+09. I have changed the formatting of the column to text and it still
happens. It looks fine if I expand the column but the problem is when I save
the file, it automatically shrinks again when I save as a csv file. Any
suggestions how to keep the numbers?