NumberAsString UDF question

2005-06-16 Thread Thane Sherrington
I'm using Ben Forta's NumberAsString and DollarAsString, and I'd like it to convert 1.00 to One dollar and zero cents, but it converts to One dollar. Is there a version that does the conversion I'm looking for? T ~| Find out

Re: NumberAsString UDF question

2005-06-16 Thread Paul Hastings
Thane Sherrington wrote: dollar. Is there a version that does the conversion I'm looking for? probably overkill but might have a look at icu4j's RuleBasedNumberFormat. we use it for spellout functionality, etc. in i18n apps but it can be made to format pretty much anything. simplified cf

RE: NumberAsString UDF question

2005-06-16 Thread Ben Forta
: Thursday, June 16, 2005 7:50 AM To: CF-Talk Subject: NumberAsString UDF question I'm using Ben Forta's NumberAsString and DollarAsString, and I'd like it to convert 1.00 to One dollar and zero cents, but it converts to One dollar. Is there a version that does the conversion I'm looking for? T

RE: NumberAsString UDF question

2005-06-16 Thread Thane Sherrington
At 09:22 AM 16/06/2005, Ben Forta wrote: Should be an easy change. In DollarAsString() you'll see a line that reads: if(cents) That checks to see if cents is not 0, so just remove (or comment out) that line and it should do what you want. Thanks Ben. T