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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Select Case" type formula 1

Status
Not open for further replies.

byrne1

Programmer
Aug 7, 2001
415
US
I want to make a formula field that will convert numeric data into text (ie, turn a 1 into "One", 2 into "Two", etc). How can I do this in CR 7.0?
 
First, see if you have the towords() function available to you. Create a formula:

towords({table.number})

If that doesn't work, then try:

select {table.number}
case 1 : "One"
case 2 : "Two"
case 3 : "Three"
default : ""

-LB
 
ToWords function worked like a champ. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top