I need to change text to numbers in Excel and use it later in a formula. For example, everytime a T is shown in a column, $6.50 is added into the formula or B is $7.50. Also, when I type in a formula with percentages such as, C2+6.5%+55%+$6.50(This is the T, I asked about earlier)the answer is wrong. In this case C2 is $5.83 and Excel calculates this as $12.945 instead of $16.12. Any suggestions?