samimichaels
IS-IT--Management
I am builing a report that is a check and need to convert the amount to the number in text: For example: $25,000.00 to Twenty Five Thousand Dollars.
How do I do this?
How do I do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Currency to text
- Thread starter samimichaels
- Start date
- Status
CrystalVis
Technical User
You have to create a formula
ToWords{DB.CurrencyField}
ToWords{DB.CurrencyField}
Dear Samimichaels:
I believe that you want the ToWords function:
ToWords({Table.CurrencyField})
For example: 1234.55
will print:
One Thousand Thirty Four and 55/100
ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
I believe that you want the ToWords function:
ToWords({Table.CurrencyField})
For example: 1234.55
will print:
One Thousand Thirty Four and 55/100
ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question