RealmSteel
12/18/2006 4:37:00 PM
I use this one.
It does spell out the cents though.
=fSpellNumber(B16, 1, "Dollar")
B16 is the cell I have the actual number in.
mkane wrote:
> I've been looking for a function or format that would convert currency to
> text to automate our company check request forms. Specifically, I would
> reference a field with currency input such as $1120.35 and display that in a
> seperate field as "One Thousand One Hundred Twenty & 35/100"
>
> Seems like there would have to be a function for this - any help?
>
> Thanks