I was very surprised that a function BAHTTEXT() exists in Excel. It converts a number to written words.
There is no English equivalent, but many functions and workarounds exist on the internet. For example the VBA function here: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-bahttext-function
Attached you will find my neat collection of VBA code to optimize your Excel spreadsheets. Enjoy!
Contact me for more info and spreadsheet development. Thanks!
After many years helping companies with their challenges as an employee I have decided to go freelance.
Danish Excel intros: Snedige regneark and 30 minutes Excel expert review.
Freelance
I get my hands dirty with operational IT and also work in the sphere between IT and business as a business consultant. My primary skill is to understand the business and convert that knowledge to simple optimized IT solutions and implement them. I have successfully implemented many pilot projects with business models created with web applications, Linux/Bash scripts, Python scripts, R-project scripts, and Excel/VBA models. Learn more on my page with services - for instance Excel Freelancer. Feel free to check out my CV too!
