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

G

Guest

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

Guest

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
 

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

Adding recognised Zeros 5
15+ digit numbers 3
Vlookup with more than 15 digits 2
more than 15 numbers in a cell? 7
Count number of digits in a cell 6
Import .csv File Problems 5
excel, how enter >15 digits in a cell without rounding off last? 3
Excel Maximum viewable numbers in a cell 2

Top