Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Help with function to sum values in a worksheet depending on account number | Excel Worksheet Functions | |||
Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions |