software

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
quot;= CONTRACTS!G19quot;, 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.
On a summary worksheet in a report, I'm linking a total to a cell on another
gt; worksheet. Once that number appears in the summary worksheet, I want it
gt; to
gt; 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