Thanks Jim it worked - I have spent hours trying to figure it out. Regards.
--
Jooles


"Jim Thomlinson" wrote:

your cell is probably formatted as text. Change it to Number or General
oranything other than text. Once it has been reformatted you will still need
to update the cell. Double click on the cell to get inot formula edit mode
and then hit <Enter to exit.
--
HTH...

Jim Thomlinson


"Jooles" wrote:

I am trying to add a cell from one worksheet to a formula in another
worksheet but it just shows the forumula in the total box instead of the
figure what am I doing wrong?
--
Jooles