Aug 10, 2005 #1 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?
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?
Aug 10, 2005 1 #2 lbass Technical User Feb 9, 2002 32,818 US 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 Upvote 0 Downvote
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
Aug 10, 2005 Thread starter #3 byrne1 Programmer Aug 7, 2001 415 US ToWords function worked like a champ. Thanks! Upvote 0 Downvote