thanks for all your answers , i got it to do it at home and worked the way
i want it to, will try now in work

thanks again

JKF


"Stefi" wrote in message
...
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