How to Set a cell to mention it in words if it is entered in Numbers?

**ksbharath86** · 11-03-2014, 08:50 AM

Hello Friends,

Here I come with another issue.

For example if I am entering a number in Cell A2 as 2500.00, then how do I make it display in words as Two Thousand Five Hundred Only in Cell A3.

**Olly** · 11-03-2014, 08:59 AM

See https://support.microsoft.com/kb/213360

**ksbharath86** · 11-04-2014, 01:29 AM

This was the perfect answer. But after adding the module in to my excel sheet it is applicable only to that particular sheet. How do I make it available to all the excel files or the new excel files which I will be creating in future. And I am using Excel 2013

**Olly** · 11-04-2014, 04:45 AM

The best way to make the function available to all workbooks is to save it in an AddIn.

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

Sorry to just reply with links, but it's easier than just retyping it all!

**ksbharath86** · 04-02-2015, 09:01 AM

I am facing some problem..

On cell On cell A8 I have applied a formula (=A1+A2+A3+A4+A5+A6) And I have set cell A8 contents to display as words. But in between when I change the values of cell A4, number to word format is not working. After adding the script again it changes.