View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katie Mac Katie Mac is offline
external usenet poster
 
Posts: 1
Default Converting imported cell from exponential form

Hello, I'm having trouble when I import data into Excel.
Any data including numbers and the letter "E" automatically appears in
exponential form.
For Example:
96E03 9.60E+04
96E003 9.60E+04
10E18 1.00E+19
10E018 1.00E+19
Is there a formula that can be applied to the cells and copied to make life
easier?


Thank you