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

P

pj

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+##.
 
R

Ron Coderre

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
 
Top