Thread: Number values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kleivakat
 
Posts: n/a
Default 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.