Prevent conversion of numeric text string to scientific notation

  • Thread starter Thread starter StuckWithExcelAlas
  • Start date Start date
S

StuckWithExcelAlas

If i type, paste, edit in situ, or text-to-column large numeric string like:
0342737749549075
it will be converted to
3.42738E+14
completely against my will. The Cell is set as 'text'
(What part of 'text' does Excel not understand??)
I'm on Mac, so that could also be the problem.
 

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

Prevent Scientific Notation 3
large numbers as text replaced with scientific notation 2
EXCEL read a text string as scientific notation 7
text converted to scientific notations 3
How do I stop Excel 2007 from using scientific notation? 2
scientific notation 4
Scientific notation from a csv file 1
Excel reading pasted values as Scientific Notation 3

Back
Top