Can you perform calculations w/ cells that have both numbers and t
I would not use a formula but rather Custom Format A1
FormatCellsNumberCustom
"Tipping Fee = "$#,##0.00
The just enter 72 or whatever number you wish and reference A1 in your
calculations.
Gord Dibben MS Excel MVP
On Mon, 27 Oct 2008 12:43:03 -0700, BWP
wrote:
Hi:
I have a cell (A1) that has the following text:
2008 Tipping Fee = $72
I want to perform calculation that reference this 72, and then if I change
the tipping fee, all of the other cells will update. Is there a way I can
make a formula identify just the value in this cell? If not, is there a way
I can hide the input value, in this case, 72, somewhere on the spreadsheet?
- Thank you! BWP
|