Forum

How to convert nume...
 
Notifications
Clear all

How to convert numeric numbers into specific words ?

5 Posts
3 Users
0 Reactions
72 Views
(@learningtoexcel)
Posts: 2
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
(@learningtoexcel)
Posts: 2
New Member
Topic starter
 

Hi Sunny,

It is exactly what I wanted. Really thanks for your input!

Appreciated!

 
Posted : 29/01/2019 12:55 am
(@sunnykow)
Posts: 1417
Noble Member
 

You are welcome.

 
Posted : 29/01/2019 2:14 am
(@dpal)
Posts: 7
Active Member
 

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
Share: