Hi Salim,

Please read this post and use the code from it

https://www.myonlinetraininghub.com/convert-numbers-currency-to-words-with-excel-vba

Regards

Phil

Hi Sir Philip Treacy 

Thanks for guide, there is a request regards this how can i add word "only" in this, i mean if i want to add only in last for example (one thousand five hundred dollar and no cent only ) please guide me

Hi Salim,

Concatenate " only" to result the function returns:

=numtowords(A2) & " only"

Regards

Phil

Hi Salim

To add to Phil's reply, you can also use SUBSTITUTE(numtowords(A2) & " only","dollars","euro"), for example.

It will replace the dollar to whatever currency (euro, in this example) that you are using.

Sunny

Dear Sir Philip

is there any method of adding word "only" by using vba code, it will be easy and good then adding ( =numtoword()&"only"), by using formula =numtoword()

Regards

Salim

Sure,

Open the VBA editor and modify the last line of the NumToWords function to this

NumToWords = Application.Trim(Units & SubUnits) & " only"

Regards

Phil

Dear Sir Philip Treacy

Thank you very much for guidance, and hope you will be guide in future also, 

regards 

Salim

you're welcome