Number values

[kleivakat]

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.

 

[Bernard Liengme]

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