convert number into text & Only

[IL]

I want to use Excel to print cheque, I want to know if I can convert the
number into text amount,

e.g. 1081.80 convert into One Thousand Eighty One Dollars and
Eighty Cents Only.

Thanks.

 

[Peo Sjoblom]

Third time today some asks about this

You can download add-ins that will do that

Morefunc

and ASAP-Utilities both can do this

both are free, Google them



Otherwise see

http://support.microsoft.com/kb/213360




--


Regards,


Peo Sjoblom

 

[IL]

But it only converted 1081.80 convert into One Thousand Eighty One Dollars and
Eighty Cents without "Only" at the end.

The important thing is that the word 'Only" has to be added at the end after
conversion.

************************************************************

 

[muddan madhu]

change the part of the code

Select Case Cents
Case ""
Cents = " only"
Case "One"
Cents = " and One Cent" & " only"
Case Else
Cents = " and " & Cents & " Cents" & " only"
End Select