Converting currency to text "One & 00/100 Dollars"
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
|