Question

Excel Spellnumber function to convert a float or number to words

0

In Excel, there is a function that spells the number / or an amount out in words. Is there a function like that in mendix? Would like to add the function in my project. E.G R43 543,00 will have an output of Forty Three Thousand Five Hundred Forty Three Rands and No Cents.

asked 2015-12-15

Desmond Chow

3 answers

Ronald Catersels · Answer 1 · 2015-12-15

No, but with a microflow you can build your own. It will take a lot of if statements though. After you finished this microflow you might want to publish this one so others can use it to. If you need pointers creating this microflow let us know, but it should be straight forward.

Regards,

Ronald

Paul Ketelaars · Answer 2 · 2015-12-15

It's not a standard Mendix thingy you can use in your project AFAIK. However, I know I've seen this in one of my projects before, but can't seem to find it at the moment.

A custom Java action might help you though. Take a look here:

http://stackoverflow.com/questions/3911966/how-to-convert-number-to-words-in-java

Nikel Kruizinga · Answer 3 · 2015-12-15

Create a Java action to do this. A number of example implementations can be found at http://stackoverflow.com/questions/3911966/how-to-convert-number-to-words-in-java .