Re: Converting Number To Text

Glad to hear it.

I started fiddling with an option to return either as moeny or straight
decimal and ran into a major rewrite.

I got it to the point where 123.15 would be "One Hundred Twenty Three
point Fifteen" but certain other differences between money and straight
decimals got complicated:

As money, 123.5 would be "One Hundred Twenty Three Dollars and Fifty
Cents." As a decimal, it would be expressed as "One Hundred Twenty
Three point Five." On the other hand, as money, 123.05 is "One Hundred
Twenty Three Dollars and Five Cents", but as a decimal would be
expressed "One Hundred Twenty Three point Zero Five."

Too much for me right now. Recuperating from heart surgery, the pain
meds fog me up.

Matt

Ben wrote:

> That was exactly what I needed.
>
> Thanks Matt
>
> Ben
>
> On 2006-01-27 12:12:07 +0000, "Matt Wills" <Im@xxxxxxxx> said:
>
> > Not without a lengthy calculation.
> >
> > There is a Custom Function at http://www.briandunning.com/cf/19 that
> > will work as a straight field calculation.
> >
> > As is, it is money-oriented, converting the number 123.15 to "One
> > Hundred Twenty Three Dollars and Fifteen Cents."
> >
> > If you don't want dollars and cents, there are a couple of Case
> > statements to remove, and probably change the "and" to "point"?
> >
> > Matt
> >
> > Ben wrote:
> >
> > > Hi
> > >
> > > Is it possible to have Filemaker convert a number to a text
> > > string, for example:
> > >
> > > 54 to fifty four
> > >
> > > TIA
> > >
> > > Ben



--

.

Relevant Pages

  • Re: calculaton and accuracy issue
    ... though you may have changed the display of the cells to two decimals ... > 2nd column entered by a formula to calculate 15% of gross ... > the third column is off by a few cents on most of the line ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Decimal Problem !
    ... types are NUMBERwith the decimals set to auto at table design ... In calculations with money you need the "exact look" of the values. ... Should I be using any other "type" of field eg. currency ... ... In bookkeeping I do not want any fraction of cents or mils, ...
    (comp.databases.ms-access)
  • Re: Need help rounding off my dollar amount
    ... I want a function to round off my dollar value. ... > had ideas of isolating the cents, tens of cents and dollar values. ... Truncate decimals ... T_Currency_1 -- test of dollar and cents rounding. ...
    (borland.public.delphi.language.objectpascal)
  • Re: Convert currency to general
    ... Then I guess you will have use the multiply by 100 trick before formatting ... 111 = one dollar eleven cents ... and I strip off the decimals leaving 250 ... I need to export information from my AP application to my bank. ...
    (microsoft.public.excel.worksheet.functions)