Converting Letters to numbers in a column?

SynderStar

Board Regular
Joined
Mar 17, 2016
Messages
93
Ok so i am very new to VBA in all forms so this is probably a simple question to answer but here it goes.

I have a couple columns in excel that i want only numbers to pop up in no matter what they type IE if they type an X i want it to convert to its numerical Value. The reason being is that i want it to allow me to use icon sets without needing them to type 1 or 2 or what have you.

The condiotnal formating i have will be anything => 1 will turn into a check mark
but if they put in text it will just stay text .. i need that text converted to numerical value so that the check mark will show up.

Any suggestions?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
What do you mean by "its numerical value" ?

Do you mean its ANSI numeric code ?

For example, when I type in "a" in cell A1, then =code(a1) returns 97.

Is this what you mean ?
 

SynderStar

Board Regular
Joined
Mar 17, 2016
Messages
93
What do you mean by "its numerical value" ?

Do you mean its ANSI numeric code ?

For example, when I type in "a" in cell A1, then =code(a1) returns 97.

Is this what you mean ?


Something like that i have never been entirely aware of what the actual values were for a given letter i just knew that the letter "X" for example was greater than 1
is there a way for me to type in "X" or even something like "completed" and have that converted to the numercial value for it overwrite it in the same cell that it was entered in?
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
What do you actually want to do ?
Do you want to see the code number ?
Or do you want to convert it into a symbol in a different font ?
 

SynderStar

Board Regular
Joined
Mar 17, 2016
Messages
93

ADVERTISEMENT

What do you actually want to do ?
Do you want to see the code number ?
Or do you want to convert it into a symbol in a different font ?

I can set a conditonal format to change to an icon set i just want it to convert to a numerical value.
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
I don't really understand your answer in post #5, and looking back at post #1, I'm getting even more confused.
So I'm afraid I'm giving up on this unless you can be SUPER CLEAR about you want to do.
Good luck !
 

SynderStar

Board Regular
Joined
Mar 17, 2016
Messages
93

ADVERTISEMENT

I don't really understand your answer in post #5, and looking back at post #1, I'm getting even more confused.
So I'm afraid I'm giving up on this unless you can be SUPER CLEAR about you want to do.
Good luck !

Haha yeah i understand ill try to clear it up

So in cell A1 or B1 i type "X" instead of "X" showing up i want the numerical value to show rather than what i actual typed.

is that possible?
 

SynderStar

Board Regular
Joined
Mar 17, 2016
Messages
93
Yeah but you also said

X = text.

I'm really out of here this time !

Yeah that was my fault i guess i did not say that was part of my problem i dont want any text to show up in those fields only numerical value.

Thank you for trying though
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top