I have a form that is used for cash purposes. In it, I have a total amount in numbers and the same total in letters. I want to convert the amount from numbers to written words. For example: if the total is $114.75, then it should be automatically converted to the text "One hundred and fourteen dolla…

[image] Xiphware: or a slightly more concise alternative if(${hundreds}>0, concat(selected-at("one two three four five six seven eight nine", ${hundreds}-1), ‘ ’ ,‘hundred’),’’) Right and this should be even better :slight_smile: numbersToWords.xlsx (11.6 KB)

Convert amount from numbers to words

Support

Grzesiek2010 October 19, 2023, 9:55pm 10

Right and this should be even better
numbersToWords.xlsx (11.6 KB)

1 Like