SpellNumber in my native language (Bulgarian)

[vikwest]

Hi, I've been looking accross the internet for a formula to spellout my numbers in excel and I came by the SpellNumber. So I edited it in my native language (Bulgarian) but the problem is that here we don't spell "one hundred" "two hundred" etc. but we have a single word for 100, 200, 300 etc. (respectively "sto", "dvesta", "trista" etc.). I was trying to work through the macro but couldn't do it. Can this be done in excel? I don't have a problem with the tens and "cents" functions, they work great. But if my number goes over 99 it is problematic.

I would be grateful if there could be a solution

 

[apo]

At a quick look.. i would say you need to concentrate in this part...

Can you list here.. expand on... ( (respectively "sto", "dvesta", "trista" etc.)).. thats the first 3.. whats the rest..?

' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber)    Dim Result As String    If Val(MyNumber) = 0 Then Exit Function    MyNumber = Right("000" & MyNumber, 3)    ' Convert the hundreds place.    If Mid(MyNumber, 1, 1) <> "0" Then        Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "    End If    ' Convert the tens and ones place.    If Mid(MyNumber, 2, 1) <> "0" Then        Result = Result & GetTens(Mid(MyNumber, 2))    Else        Result = Result & GetDigit(Mid(MyNumber, 3))    End If    GetHundreds = ResultEnd Function</pre>