Razvan Posted April 17, 2008 Share Posted April 17, 2008 Hi everyone, I need help with the following situation: I have two fields. I need to type numbers in the first one and automaticaly convertit in letters in the seccond one. Ex: field 1 says: 100 field 2 rezult: one hundred or field 1 says: 125 field two rezult: one hundred and twenty five or field 1 says: 125.50 field two rezult: one hundred and twenty five and fifty cents. I tryed the function "Case" but i can only make cases for one letter at a time and I don't have a clue how to make an algorithm so I don't have to make a "case" for every posible number... smiley-smile Thanks Razvan Link to comment Share on other sites More sharing options...
AHunter3 Posted April 17, 2008 Share Posted April 17, 2008 There have been several threads on the subject. Here's one Link to comment Share on other sites More sharing options...
Razvan Posted April 17, 2008 Author Share Posted April 17, 2008 Thank you AHunter3! That was verry helpfull. I'll translate and adapt this code to romanian and postit here in case someone else need it. Razvan Link to comment Share on other sites More sharing options...
J Wenmeekers Posted April 17, 2008 Share Posted April 17, 2008 Razvan, I do not think you can do it by simply translate the English version. In your language you have nearly the same problem as f.i. in Spanish. In English the numbers stay singular, in Romanian they change. sută become sute, See how far you can get and if need be we can jump in with an example. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts