February 6, 200223 yr Is there a way of converting a dollar amount such as $1285.73 into text by definition or script as one thousand two hundred eighty-five and 73/100 dollars?
February 6, 200223 yr Yep, it can be done. You need to do some nitty gritty calculations and using a couple of help fields or lookups would work. By converting the number to a text field you can isolate the numbers. Or use the truncate function, it also allows negative numbers, so trunc(1285,-3)/1000 is 1. And trunc(1285,-1)-trunc(1285,-2) gives 80, divide that by ten and you have the 8! Then a bunch of cases of lookup to turn 8 into eigthy... Just grab a piece of paper and have fun with the formulas. There's a lot of different ways to do it. I've you need help let me know. Greetings Ramon
Create an account or sign in to comment