View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RealmSteel[_2_] RealmSteel[_2_] is offline
external usenet poster
 
Posts: 9
Default 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