Forum Discussion

SamSam1's avatar
SamSam1
Qrew Member
11 years ago

How can I get the text of a number in the way one would speak it? For example $100.00 = One Hundred Dollars

I could do it with this formula! var text numt = ToText(Floor([Number])); var text cents = If(Contains(ToText([Number]), "."), Left(Right(ToText([Number]) & "00", "."), 2),""); var text teens...
Formulas and functions
Tables and fields
rahulrahul1's avatar
rahulrahul1
Qrew Trainee
9 years ago
Hi Sam, I am using the above formula but i noticed one issue if we give single digit number 2 then its returning "and two dollors" :(
Example - Number = 11600 then formula is giving value "Ten One Thousand, Six hundread dollars" ideally it should say "Eleven thousand and Six hundread dollars" ? i am trying to fix it but would be great if you can tell me which variable is causing this issue?

It would be great help if you can provide us the upgraded formula if you have. or atleast can guide me where to make the changes to achieve the goal :)
UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
6 years ago
I noticed this as well, did you get any update on this?