Hi,

Are your Cells formatted as Number?

You can check this by Selecting FormatCellsNumber, then select Number form
the list.

Hope this helps,

Gav.
"jkf" wrote:

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