linking nmerical value to text?

[KeithQuigley]

hi all,

I want to know how to have a numerical value of a cell but with the cell text being a word, how do i do it in excel '07?

I want it so when i look at the cell i can see when the cell is(text) but when i multiply it by another cell the figure will be used?

 

[Special-K99]

whats your data look like?

 

[VoG]

An example would help.