"Select Case" type formula 1

[byrne1]

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?

 

[lbass]

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

 

[byrne1]

ToWords function worked like a champ. Thanks!