# Excel Numbers to Text & Percentages in Formulas

#### elisagarrett

##### New Member
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?

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
On 2002-09-29 09:45, elisagarrett wrote:
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?

Hi Elisa:

Welcome to the Board!

Elisa 5.83+6.5%+55%+6.5 does come out to \$12.95

Perhaps you are trying to compute:
=5.83+6.5+55%+6.5 -- that will compute to \$19.38

see the worksheet simulation ...
y020929.xls
BCDEF
1
25.83
3
4\$12.95\$19.38
5
Sheet12
</SPAN>

Regards!

Yogi

On 2002-09-29 09:45, elisagarrett wrote:
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?

I could be missing a lot of information so I will make some assumptions.

You use code for a variety of values.
You could access this information with
If, Vlookup, Lookup, Hlookup, Choose etc.

The Lookup information could be in the formula or refer to a range. I named a range
(LookupV) with the letters in one column and the values in the next.

=(C2+6.5%*C2)*1.55+LOOKUP(B2,LookupV)

Replies
2
Views
171
Replies
48
Views
1K
Replies
6
Views
719
Replies
14
Views
419
Replies
7
Views
136

1,207,095
Messages
6,076,552
Members
446,213
Latest member
bettigb

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back