‘Numbers to Words’ Batch Converter (Num to Text)

Recently I needed to convert a series of currency numbers to words equivalent. Strangely Microsoft Excel does not have any in-built corresponding function to handle this. I wrote this code to get this done with support up to quintillion values. Now that should be sufficient for most of the cases.

Truth be told, I could not find what comes after quintillion.

You can use this to convert unlimited numbers of numbers.

The output is provided in tabular format – you can just copy paste the output back into your excel worksheet.

I have tested this on a large set of numbers and this works perfectly well.

Should you have a feedback or need some new functionality added – do let me know.

And please share if you find it useful :)
















Example output

15USD Fifteen only
212227USD Two hundred and twelve thousand, two hundred and twenty-seven only
2122USD Two thousand, one hundred and twenty-two only
545USD Five hundred and fourty-five only
2128USD Two thousand, one hundred and twenty-eight only
21212USD Twenty-one thousand, two hundred and twelve only
45.12258USD Fourty-five point one two two five eight only
21212USD Twenty-one thousand, two hundred and twelve only
5458.56USD Five thousand, four hundred and fifty-eight point five six only
14122.6565USD Fourteen thousand, one hundred and twenty-two point six five six five only

One comment on “‘Numbers to Words’ Batch Converter (Num to Text)

  1. Pingback:‘Numbers to Words’ Batch Converter (Indian Numbering System)

Comments are closed.