New
#1
Excel 15 digit number limit issue
Try this. Type a 16-digit number in a cell, say:
1234567890123456
Then right click the cell and format this as a number, with no decimal places.
Your number has just become:
1234567890123450 (note the last digit is now a zero).
great stuff. Not. It has effectively corrupted your input (changed your value) without notifying you in any way that you've hit a limit.
My question is - is this known behaviour for Excel 2007?