Converting a number to written text

[DerekJeterGirly]

Is it possible to have a cell's sum convert to write out the sum in long verion?
Example cell D3's sum is $100.00 and I reference cell F20 to equal sum of cell D3 but display it as One Hundred Dollars and 00/100. This may be hoping for too much, but it would make my task a lot easier.

 

[Barrie Davidson]

On 2002-03-12 07:46, DerekJeterGirly wrote:
Is it possible to have a cell's sum convert to write out the sum in long verion?
Example cell D3's sum is $100.00 and I reference cell F20 to equal sum of cell D3 but display it as One Hundred Dollars and 00/100. This may be hoping for too much, but it would make my task a lot easier.

Have a look at:

http://www.barasch.com/excel/numb2words.htm

Regards,