Convert Numbers/currency to Words (Rs, Dollar, Any currency) formula in Excel | Excel Spell number

#spellNumber #number#to#word
Converting numbers or currency to words is most common issue faced by user. One may require spelling number or amount to letter for various reasons like in cheque printing, invoice printing, HR appraisal letter.
This video will show you how to spell numbers or convert numbers into words using VBA UDF easily.

f_spellNumber UDF function has 3 inputs
num - Compulsory, which can be a cell reference or hard number
unit1 - Optional, which is currency name like Dollars, Rupees Etc.
unit2 - Optional, which is fractional currency names like Cents, Paise Etc.
By using the f_spellNumber UDF function in Excel one can spell numbers into any currency like Indian Rupees, Dollar, Riyadh, or in any currency which you want.

✔✔ Jump to a section
f_spellNumber syntax and inputs 00:54
Making f_spellNumber UDF 01:36
Spell amount into Indian Rupees and USA Dollar 03:15
Making Addin to UDF available in all workbooks 04:53

Click the below link to download the file.

===================================================
🌐 Websites 🌐
===================================================
📌📌You can watch and learn from the below videos also.📌📌
-Spell number in Hindi/Devnagari in Excel

-Create custom / user defined functions or udf in excel using VBA.

-UDF formula to get cell comment text.

-Vlookup to return duplicate matched values or return all matched lookup values - method 2

-Get value from the first visible cell in filtered range

-How to get Quarter from a date in Excel?

-Abbreviation Function In Excel (VBA UDF for Short form|Abbreviation)

[LearnYouAndMe]

f_spellNumber syntax and inputs 00:54
Making f_spellNumber UDF 01:36
Spell amount into Indian Rupees and USA Dollar 03:15
Making Addin to UDF available in all workbooks 04:53

[ignacio]

it works perfectly well up to thousands with two digits, after that it has a digit order number which I had no idea even existed! Could you not make something that worked like normal;567.235 five hundred and sixty-seven thousand.... and the same with with millions?