Special Code
hI Rao, I received this code from Aidan,
On the spreadsheet, press ALT+F11 open a new module copy and past this code:
Function GetDigit(Digit As String)
Dim CheckDigit As String
Dim looper
For looper = 1 To Len(Digit)
CheckDigit = Mid(Digit, looper, 1)
Select Case Val(CheckDigit)
Case 1: GetDigit = GetDigit & "G"
Case 2: GetDigit = GetDigit & "O"
Case 3: GetDigit = GetDigit & "L"
Case 4: GetDigit = GetDigit & "D"
Case 5: GetDigit = GetDigit & "E"
Case 6: GetDigit = GetDigit & "N"
Case 7: GetDigit = GetDigit & "C"
Case 8: GetDigit = GetDigit & "I"
Case 9: GetDigit = GetDigit & "T"
Case 0: GetDigit = GetDigit & "Y"
Case Else: GetDigit = ""
End Select
Next
End Function
so, imagine you have the 100 on the cell A1 the formula is:
=getdigit(a1)
regards
"Rao Ratan Singh" escreveu:
I want to generate price list with this
G = 1
O = 2
L = 3
D = 4
E = 5
N =6
C= 7
I = 8
T = 9
Y = 0
When i enter 100 it should return GYY
HOW IT IS POSSIBLE
Thanks and regards
RRS
|