View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
madubois9
 
Posts: n/a
Default Converting text to excel

When I convert a .txt document to excel, my columns are all formatted to
general, and hwne I change them to numbers, it adds a zero at the end of the
numbers in one of my columns. The number is a 13-16 digit long number and as
an example it show in the cell as: 512345E +15. How do I avoid the extra zero
at the end of my number?