Scientific Notation

  • Thread starter Thread starter rICH
  • Start date Start date
R

rICH

Is there a way to prevent excel from automatically
converting certain numbers to scientific notation?

Example-when importing data, '760985E56' automatically
converts to '760985E+61'.
 
How are you importing? If you're importing a text file, use the Text
Import wizard, and in the third pane, click the field header and choose
the Text radio button
 
Back
Top