Discussion Locked

Entering more then 15 digit in Excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I'm having problem entering more then 15 digit in Excel XP cells, is there any way to get around this problem, thanks

1 reply

by dklippert

Regardless of the number of digits displayed, Excel stores numbers with 15 digits of precision. If a number contains more than 15 significant digits, Excel converts the extra digits to zeros (0).

If you convert the entry to text (Put an apostrophe (') in front of the entry you can enter more digets, but you can't use them for calculation.

This discussion is closed to new replies.