Thankis for the help partly helped - finishing it off by double clicking on
cell and pressing return changed it to the number. Regards.
--
Jooles


"Michael M" wrote:

Firstly, post the formula you are getting
and secondly make sure you have formatted the cell as number.

Regards
Michael M

"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