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

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

Guest

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
 
S

stevensmith

Joined
Sep 13, 2012
Messages
1
Reaction score
0
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?
 

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

How do I get MS Access to Read Scientfic Numbers from a Text File? 8
Macro to Change Changing Date Format Data to Text 3
connecting wordpad and excel 1
Date conversion on text file import 5
How to convert text "JAN" into number 1? 9
Importing a text file 1
12 Digit converting in excel 2003 4
Convert Text To Number 4

Top