Dear Madam,
Let me tell you first, I am not a student of word but infuture I am looking to join your word course as well because I realized ms word is also important alongwth excel.
For this time if possible please help me to I will be really thankful to you.
I have excel sheet where I have customer name /currency/amount/location and date.
I wanted the amount to be converted into words and do the mail merge as per attached letter format.
Can you please help.
Hi Sarfraz,
Please see this tutorial on converting numbers to words with VBA in Excel: https://www.myonlinetraininghub.com/convert-numbers-currency-to-words-with-excel-vba
Note: this is outside the scope of the Excel Expert course, so if you get stuck, please post your question and sample Excel file on our VBA forum where someone can help you further: https://www.myonlinetraininghub.com/excel-forum
I hope that points you in the right direction.
Mynda