9.89E+09 Why this instead of a 10 digit number in cell?

  • Thread starter Thread starter Tim Fitch
  • Start date Start date
T

Tim Fitch

When I paste (regular or special) a 10 digit number
beginning with 989, I get 9.89E+09 displayed in the actual
cell, even though the actual 10 digit number appears in
the box above that is suppose to be showing what is in the
cell. All cells involved are formatted to General, and
changing the formatting to Text leaves the same oddity.
 
Make the column *wider*.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I paste (regular or special) a 10 digit number
beginning with 989, I get 9.89E+09 displayed in the actual
cell, even though the actual 10 digit number appears in
the box above that is suppose to be showing what is in the
cell. All cells involved are formatted to General, and
changing the formatting to Text leaves the same oddity.
 
That works, but why would I get 9.89E+09 instead of the
usual series of number signs for a too-narrow column?
 
Make the column *narrower*!
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

That works, but why would I get 9.89E+09 instead of the
usual series of number signs for a too-narrow column?
 
You must log in or register to reply here.

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

Number of significant digits allowed in a cell is 15. 2
How add a digit to front of number in each cell in excexl column 1
Turning a 9 digit string into zip+4 3
Converting a 10 digit serial number to a date of mm/dd/yyyy 7
Display entire number in cell 3
formatting a cell 2
I cannot enter a number containing more than 15 digits in Excel 1
When I enter a number, why do I get #### appearing instead of dig 2

Back
Top