We have a major power outage in Ohio due to a wind storm on Sunday. AEP, Our electric provider says that power would be restored to my area by this Friday midnight, that is almost 6 days without power. I will not be able to blog regularly during this period.
So here is a list of 99 excel tips that are posted here in the past. Browse them and enjoy 🙂
- 3 Impressive Excel Charts you should try – Thermometer Charts, Min-Max Charts, Incell Tag Clouds
- 4 Steps to Create Marvelous KPI Dashboards
- 5 Microsoft Excel Conditional Formatting Tips
- 6 Things you dont Know about IF() Formulas
- 6 Excel Charts you should never use
- 7 Spreadsheet Microcharting Alternatives for your Dashboards
- 10 Tips on using Date / Time in Excel
- 11 Really Useful Excel Keyboard Shortcuts
- 15 Excel Formulas you may not know
- 15 Fun things you can do with Excel
- 17 Excel Copy Pasting Tricks you may not know
I am planning to make another post or two during this week, otherwise regular broadcasting should resume next week.
5 Responses to “Number to Words – Excel Formula”
As well as the Indian version, perhaps you could look into an English version as against the American version.
Things diverge after one hundred with one hundred one OR one hundred AND one.
I'm sure that it is always AND after n00 or n00,000 where there any of those zeros have a value. So five hundred thousand and sixteen. There could be two and's seven hundred and eighty-six thousand four hundred and twenty-six.
Chandoo, you are a genius.
Hi Chandoo,
Please take a look at my NumToWords and NumToDollars formulas that I shared here:
https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433
That is a genius technique Robert. Thanks for posting it here.
100000000 One Hundred FALSE Million
Is there any reason for this error?