Converting Letters to numbers in a column?

[SynderStar]

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?

 

[Gerald Higgins]

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]

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]

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]

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]

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]

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?

 

[Gerald Higgins]

Yeah but you also said

if they put in text it will just stay text

X = text.

I'm really out of here this time !

 

[SynderStar]

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