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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

worbus3 - 26 May 2006 22:13 GMT

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.

Reply to this Message

barl0w - 26 May 2006 22:29 GMT

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

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

Reply to this Message

Peo Sjoblom - 26 May 2006 23:59 GMT

Widen the cell

Regards,

Peo Sjoblom

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

Reply to this Message