Converting dollars to text

[WiseGuy]

i would like to convert dollars that have been calculated into text. Example in one cell there is a formula that has added up a group of numbers to come to a total of $6,574.70. In another cell I want to read this amount but write it out into alpha text so it reads SIX THOUSAND FIVE HUNDRED SEVENTY FOUR DOLLARS AND SEVENTY CENTS. The dollars amounts can be daily on each invoice. Any comments appreciated. I believe a formula is required

 

[Andy Brown]

I believe a formula is required

Code is required ; see this link.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

Rgds,
Andy

 

[WiseGuy]

Thanks So Much ANDY :~)
--
kw

Code is required ; see this link.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

Rgds,
Andy