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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what is a scientific notation#? 4
large numbers as text replaced with scientific notation 2
How do I stop Excel 2007 from using scientific notation? 2
Prevent Scientific Notation 3
Custom cell format for Scientific Notation 4
Excel converts 9-digit string to sci. not. when saved as csv 1
Excel's localization of scientific notation 1
Number Formatting help 3

Top