It's because the max length of numbers in Excel is 15 digits. If these long
numbers are some kind of code, Format cells as Text BEFORE entering values in
them!

Regards,
Stefi


€žjkf€� ezt Ã*rta:

any help on this would be appreciated , i am trying to insert a 20 digit
number into a work sheet, but it does not appear as i want it

example: 74540182653438069674 is what i want but what appears is
7.45402E+19



also in the bar under the tools (sorry not sure what it is called) the
number there changes to 74540182653438000000

thanks in advance for any help

JKF