Hi,

Is there any formula by using that we can convert number into text e.g. 1523 One Thousand Five Hundred Twenty Three.

I have got one i.e. BathText() but it's result is not in English.

I have macro also but that has to be always insert in a spreadsheet where I want to use this function.

Please help

As a formula, no. it would be impossibly long since numbers can be any length. You could probably construct a small formula that worked with small numbers.

There's an english "SpellNumber()" function that you can install that works well. You can find it here.

Excel: Convert Numbers to Words/Text

Quote:

---

Originally Posted by JBeaucaire

As a formula, no. it would be impossibly long since numbers can be any length. You could probably construct a small formula that worked with small numbers.

There's an english "SpellNumber()" function that you can install that works well. You can find it here.

Excel: Convert Numbers to Words/Text

---

Thanks JBequcaire,

You have always helped me.

I have this macro which I am using in some excel files. Is there any way I can get this macro available for all files so that I just go to Insert>Function>User Defined and same macro executes it for me.

You can convert your custom UDFs (just one or a whole collection of them that you utilize) into an ADD-IN, a file usually in the form of .xla or .xll file that opens every time you start Excel. This "ADDIN" approach also makes it easy for you to give your custom function to others for very easy installation.

Here's a page that serves a primer for converting UDFs into ADDINS:

VBA Tips: Build an Excel Add-In


PLEASE read the caution found at the very bottom of the file, it's very important!