Notifications
Clear all
VBA & Macros
5
Posts
3
Users
0
Reactions
72
Views
Topic starter
Hi, Philip
I copy and paste the code from your NumToWords function but I need something a little different.
Example :
10001.05 >> Ten Thousand One Dollars and Five Cents
To become :
10001.05 >> Ten Thousand One and Cents Five Only
Please assist further.
Posted : 27/01/2019 9:41 pm
Hi
See if this helps.
If the amount is 10.00 (without cents, for example) then it will show Ten Only without the Cents.
Sunny
Posted : 28/01/2019 9:06 pm
Topic starter
Hi Sunny,
It is exactly what I wanted. Really thanks for your input!
Appreciated!
Posted : 29/01/2019 12:55 am
You are welcome.
Posted : 29/01/2019 2:14 am
When I try this it comes up #NAME?
Even if I change the dollar amount in your example above.
dpal
Attached is the spreadsheet of the example above.
When you change the number the text does not change as well.
Can you help.
Thanks
Posted : 10/07/2019 2:37 pm