Thank you for your replies - unfortunately I neglected to mention that the
formula is in a cell that is spread across to cells that are merged and the
cell that I want to put a copy of the total is in only a portion of the two
cells that the original result is in.
When I try to use your methods all I get in the cell that is supposed to be
a copy is "0.50"
--
Steven.

In God we trust, all others we virus scan.