Entering more then 15 digit in Excel
Hi,
I'm having problem entering more then 15 digit in Excel XP cells, is there any way to get around this problem, thanks
Software
Hi,
I'm having problem entering more then 15 digit in Excel XP cells, is there any way to get around this problem, thanks
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.
Sort by Trending