More than 15 digits in excel cell it turns them to zeros. Fix?
 

If you put more than 15 digits an a cell and hit enter, the cell automatical
turns all the digits past the 15th one into zeros. Is there a way to correct
this?

More than 15 digits in excel cell it turns them to zeros. Fix?
 

Excel can only handle 15 digit numbers.

Hoping that you really need a text string of numeric characters and not an
actual number that big....

Either start the entry with an apostrophe ( ' )
OR
Format the cells as text before entering
<format<cells<number tab....Category: Text

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lisa" wrote:

If you put more than 15 digits an a cell and hit enter, the cell automatical
turns all the digits past the 15th one into zeros. Is there a way to correct
this?