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.
|