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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ToText & ToWords Functions in Formula Field
- Thread starter lab509
- Start date
synapsevampire
Programmer
It's well documented in Help, what is your intent?
Totext is equivalent to Cstr, and converts numerous data types to a string, here's an example of a numeric:
Totext(1234.56,0,""
Returns 1234
The 2nd parameter states the number of decimal places, the 3rd designates the character to use as a thousands seperator.
Towords is a throwback to Crystal's early days of being a check writer, and allows for numerics to be converted to words, as in:
ToWords(12345.5000,0)
Returns twelve thousand three hundred forty six.
Note that the 2 parameter states the number of decimal places to honor.
-k
Totext is equivalent to Cstr, and converts numerous data types to a string, here's an example of a numeric:
Totext(1234.56,0,""
Returns 1234
The 2nd parameter states the number of decimal places, the 3rd designates the character to use as a thousands seperator.
Towords is a throwback to Crystal's early days of being a check writer, and allows for numerics to be converted to words, as in:
ToWords(12345.5000,0)
Returns twelve thousand three hundred forty six.
Note that the 2 parameter states the number of decimal places to honor.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question