View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BWP BWP is offline
external usenet poster
 
Posts: 2
Default Can you perform calculations w/ cells that have both numbers and t

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