Conditional Number Format - To Be Used As Number

In Excel 2003, I have a series of complex(ish) lookups which populate cells in Sheet 1 from other sheets in the same workbook. Some of these cells are %ges some are not, I need to display the resultant sheet values as %ges or not based on if the cell to the left (also populated by a complex(ish) lookup) contains the character "%".

I cannot just format the cell on its own, as the list in itself is volatile and can change according to the complex(ish) lookup,

The main problem with this is I need the result to be a numeric value and NOT text in ALL cases as further calculations will be undertaken on them.

In simple if it is a %ge I need to see the %ge and use it as a %ge or if it is just a number see it as a number and use it as a number.

e.g

A B Result Req
Satisfaction with telephone access (%) 0.900032390.0%
Ability to see boss within 48 hours () 0.889 0.889