Why does excel convert my text "6990011011234" to "6.99E+12"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why does excel convert my text for example "6990011011234" to "6.99E+12"?
I am runing a "import to excell" from a web site. When imported, the
identification # is changed to #.###E+##.
 
Excel doesn't know it's text.

Either put an apostrophe in front of it:
'6990011011234

or change the number format of the cell:
Format>Cells>Number tab
Category: Text


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
I can see that excel does not know it is text but that does not really answer the question what is with the abbreviated number and +12 how does that help?
 
Back
Top