View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Why does excel convert my text "6990011011234" to "6.99E+12"?

Excel doesn't know it's text.

Either put an apostrophe in front of it:
'6990011011234

or change the number format of the cell:
FormatCellsNumber tab
Category: Text


Does that help?

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

XL2002, WinXP-Pro


"pj" wrote:

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