convert number into text & Only

I

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.
 
I

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.

************************************************************
 
M

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
 
Top