General discussion

Locked

Entering more then 15 digit in Excel

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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Entering more then 15 digit in Excel

by DKlippert In reply to Entering more then 15 dig ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Software Forums