Vba code for Amount to Words.

[riya]

Good Day,
I want to understand is there any formula or function is available in VBA where we can convert Amount in Words.

Ex. 1024 should be - One Thousands Twenty Four.

 

[shrivallabha]

If you google then links like below come 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

 

[riya]

If you google then links like below come 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

Noted Shri, that mean there is not any simple function to convert the same? we have to write lengthy code.

 

[vletm]

riya
You used term simple ...
Did You really check that link?
1) You copy and paste that code as there has written.
2) You can use it as =SpellNumber(YourGivenCellOrAmount)
...hmm?
You wrote we have to write lengthy code.
Why? Isn't Your wish to have something ... simply?