I type number 86290378 and hit enter and get formula 8.6E+07. Why

W

worbus3

I type in the number 86290378 and hit enter and this is what appears in the
cell 8.6E+07. Why? Even if I delete the cell and try again the
same formula appears.
 
B

barl0w

Excel is truncating the number. After entering the number, highlight the
cell, and go to Format, Cells. Select the Number Tab, and click on General
and OK. See if that clears it up.

You might have a spreadsheet that has weird formatting already applied to
it, as a new workbook for me didn't reproduce your error in Excel 2003 or
Excel 2007 beta 2.

Regards,

Scott
 

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Using Styles In An Outline 0
formula writes itself 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Word 2003 won't exit 8
#VALUE error which disappears when I use F2, ENTER 1

Top