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

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

RagDyer

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

Tim Fitch

That works, but why would I get 9.89E+09 instead of the
usual series of number signs for a too-narrow column?
 
R

RagDyer

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?
 
B

Bob Flanagan

You get the scientific notation because Excel is "helping" you. If you type
a single quote: ', in front of the number, it will all be visible.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Top