If only there is paste special [17 paste special tricks] for everything in life, things would be much more smoother and fun. Alas, the paste special is limited only to excel.
Here is a handy trick you can use to quickly scale up data validations set up in one cell to say a range of cells.
Just copy the cell by pressing CTRL+C and then go to the target cell(s) and press ALT+ESN. And your data validations are pasted in the new cells. That is all. Quick and Easy.
Using this, it is very easy, for eg. to copy the data validation you have setup to accept only unique values in cells from one work sheet to another.
Browse more quick tips.
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?