Got it !!!

Now, the amount right now is $1,583.00 <--- this is exactly how it reads.
and the letter amount says:
One Thousand FiveHundredandeightythree Dollars and Zero Cents.
is there any ways to make it separate by itself? like:
One Thousand Five Hundred and eighty three Dollars and Zero Cents.
This will help a lot.
It seems everytime the numbers are together, it will too make the
letters go together. Let me know, and thank you for all your guys help.

--
Computer Tech


"Gord Dibben" wrote:

The code is to be pasted into a General Module in your workbook.

The.............Say you have 123.33 in A1

In B1 enter =SpellNumber(A1)


Gord Dibben MS Excel MVP

On Wed, 8 Nov 2006 11:49:01 -0800, Edgar wrote:

ok. I have the CODE. now I put it in and nothing happens with that cell.
Do I have to click the cell where I want this info to go? but how is it
going to know what to convert to Text?
Thank You...