MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel's 15-digit limit

Posted by Merle Mason on November 15, 2000 2:11 PM

Is there any workaround for the 15-digit limit? I need
sixteen-digit numbers in a column, and the last number
isn't always zero (they are ID #s, not values).
Any digits from 16-on show up as subscripted in the
Edit Formula field as you enter them in the cell.
The cell is formatted as Number, with zero decimal
places and no commas. I read the Help
file about the 15-digit limit, but I thought I check
here to see if anyone knew of a workaround. Thanks!

Posted by Tim Francis-Wright on November 15, 2000 2:47 PM

If you format the cells in question as Text,
Excel displays the entries exactly as entered.
(You will still be able to perform mathematical
operations on them, subject to the 15-digit
limit on significant digits)


Posted by Merle Mason on November 16, 2000 8:53 AM

It certainly does help! Thanks so much!