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!