Numerical value convert to Text (Not Words

Guys,

I'm looking for a way to convert numerical value at first cell into text values at second cell since I need a text code which I can only decipher. I already made some research and only found =Spellnumber function (VBA) which convert the numerical value into word value. The =Spellnumber function is the closes to what I want to happen but not in word value but in text value.

Here is what I need to happen;

I have a secret words "WUNKY PREFIX" and each letter represent a number as shown below.

W = 1
U = 2
N = 3
K = 4
Y = 5
P = 6
R = 7
E = 8
F = 9
I = 0
X = .

When I input numerical value of 123.45 at A1 cell. The B1 cell will show WUNXKY.

Few more samples:

3467 = NKPR
83.562 = ENXYPU
25903.31 = UYFINXNW
887 = EER
11 = WW


I really appreciate for does who could help me. I need it to create a compilation of investment price, wholesale price, & retail price of each items. Thank you!

Or...

Please Login or Register  to view this content.

Both VBA Functions worked perfectly! Thank you! sourabhg98 & Phuocam

You're welcome!
You can convert from text to numbers:

Please Login or Register  to view this content.

Use...
=TextToNum("UYFINXNW") return 25903.31

Thanks again Phuocam. I will invest on it for future use.

By the way. Is it possible to add two little modification on NumtoText function:

1. If no decimal value input at first cell, the second cell will still output "X" at end of the Text.
2. When "." is input at first cell, the second cell will output "X" and "A" at end of the Text.

Sample:
1234.5 = WUNKXYA
987.21 = FERXUWA
1234 = WUNKX (no "." input, no "A" at the end of Text Output but "X" will be the end of the Text Output.)
4574 = KYRKX


I figured the Secret Code I'm using is easily decoded without extra text.

Thank you in Advance!

You could add this line between Next and End Function

Please Login or Register  to view this content.

TextToNum would also need modifying in order to decipher the code.

Thank you jason.b75

It work and this will do.