View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Clark Ken Clark is offline
external usenet poster
 
Posts: 1
Default opening text file converts numbers to scientific notation

If I open a text file containing 13-digit barcode numbers for stock using
Excel 2007, the numbers are converted to scientific notation. I don't have
the option to specifiy that I want 13 digits with no decimals, but I believe
this was possible in earlier versions. Is there a workaround or a preference
i am missing?