Need a Ukraine Number-to-Text description macro

[welchs101]

Hi, I recently asked about a Russian NumberToText or NumberToWord macro. I was able to get one at this link.

Now i have a need for the exact same thing but now for Ukraine.

I am enclosing a copy of the Russian Program. The program also has an optional input to the function where user can specify Rubles, Dollar or Euro. Based on these inputs the
program will output appropriately.

[macropod]

So what have you tried? You already have them for English and Russian. Forums such as this are not simply free coding services for those who can't be bothered making an effort.

[welchs101]

If i was asking about a program in ENGLISH i would agree with you. But the part that I am asking for help on is the part that is the Ukraine part.

In the macro, there are i think 7 , unicode to string sections, where one needs to know the language and then also because of the dialect a formula

will need to be generated. From the Russian link the person who helped me pointed me in the direction of a Ukraine program

and in this program i think i can use the "formula" but the unicodestrings stuff i still need some help with.

Again, if it was in english.........i would not even be writing .........

[BMV]

Probably i can combine two function to one and get and Russian and Ukrainian.

[welchs101]

if its easier to keep as two separate programs thats fine

[BMV]

hm i attached it two times but...
File was removed.

[welchs101]

thanks BMV i will check it out ......thanks!!!!!!!!!!!!!!!!!!

[welchs101]

hi, i used the macro to generate some output and then i had a friend of a friend of a friend (so many persons removed) review the list and let me know if the output matches what should be there for Ukraine.

They found some differences between the "Output" and "Person.....person coming up with the value"

See enclosed file for details of the differences. Also, person mentioned that 20,30,40,50,60,70,80,90 appear to maybe in Russian instead of Ukraine. I dont know and wanted to ask you about that.

[BMV]

I corrected some values. Sorry There were some mistaks mine and google translate.

[mjr veverka]

welchs101, why don't you use this subforum ?

https://www.excelforum.com/non-english-excel/

I think you will find the answers to your questions faster.

[welchs101]

I think there might be another error. In the unicode where you have "105" i think this value might should be "1110".

See enclosed file. Visually the program output "Col=Ex1" and "Ex2" are the same....visually but excel says they are different. In another post someone figured out that
the "i" in our programs output is "105" and i think it should be "1110".

What do you think?

[BMV]

Yes, some characters i copy past and some enter manually. You could replace 105 to 1110.

[welchs101]

ok....i will replace if you think its ok. Replace ALL 105 to 1110? Just want to make sure.

Thanks again!

[welchs101]

After making the 105 to 1110 change i still get a few differences between what the program is giving and what a friend of a friend of a friend says the number should be.

I am enclosing the comments ........was hoping you could take a look........is what the friend is suggesting "more correct"?

[BMV]

welchs101 . I compared the words you have marked but they are equal. But jast difference in the last word and probably your translating chain is wrong. I have got the small table from Kiev
Rub, Dol, Euro Cent
1. рубль, долар, євро, цент
2. рублі, долари, євро, центи
5 рублів, доларів, євро, центів


So in the case of .01, .21, 31, ..... .91 - цент
.02, .03,.04,.22, .23, .24, , ..... .92, .93,.94 - центи
others центів