Scientific Notation

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'.
 
J

JE McGimpsey

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
 
Top