convert number into text & Only
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
On Sep 17, 1:26*am, IL wrote:
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. *
************************************************** **********
"IL" wrote:
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.- Hide quoted text -
- Show quoted text -
|