Currency to words?

[John Kitchens]

Hello,

I once again have a problem that I need help with.

I have designed a payroll program in Excel 2000. So far it works great. I am
trying something new with it.

On Sheet1 I have the information. I have designed pay stubs on sheet 2 (Emp
Stubs).

I have the info from sheet 1 carried over to the Emp Stubs sheet through the
use of the following formulas:
=SUM(Sheet1!H9)

I know this is a lot of work when I could probably just buy Quicken, but I
really need to keep using this method.

NOW MY PROBLEM.

I need to be able to take currency, for example $717.13 and convert it over
to words, for example
Seven Hundred Seventeen and 13/100

I would like for it to take the cell containing the currency and place it in
word form in the cell that I tell it go.

Is there a way that I can do this?

Sincerely,
John Kitchens

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[John Kitchens]

Hello Frank,

That did it! Thank you so much for your prompt answer.

John Kitchens