Number values
 

On a summary worksheet in a report, I'm linking a total to a cell on another
worksheet. Once that number appears in the summary worksheet, I want it to
be a number and not a reference to the other worksheet.

For example, if the number is $1,750, the cell actually shows
"=+CONTRACTS!G19", which is the worksheet and cell where that number comes
from. However, in another cell I want to subtract $1,750 (not the number on
the Contracts worksheet.)

How do you refer to the number, and not the cell reference where it comes
from? Thanks for any info.

Number values
 

On a summary worksheet in a report, I'm linking a total to a cell on another
worksheet. Once that number appears in the summary worksheet, I want it
to
be a number and not a reference to the other worksheet

If that is REALLY what you want:
1) copy the cell
2) use Edit | Paste Special and check the Value box

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email