convert amount into words like check writing

[BABU Baru]

Can any expert help me please? I want VBA code to convert any amount into words'
for example, $1234567.89 should be written as one million two hundred thirty-four thousand five hundred sixty-seven and 89/100 dollars

 

[dalvin647]

Hi BABU Baru,

I just did a google search and this came up.

Convert numbers into words - Microsoft Support

Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.

support.microsoft.com

You could try it.

Thanks!

 

[BABU Baru]

Hi BABU Baru,

I just did a google search and this came up.

Convert numbers into words - Microsoft Support

Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.

support.microsoft.com

You could try it.

Thanks!

This code didn't work with Excel 2016