How to convert a number into word in ms-excel 2007 and 2010? example: 789 - Seven Hundred and Eighty Nine.

By right clicking the drop down box on the cell and clicking on the format where we can choose number, general, date, time...etc

Hi Mohd,

We can convert numbers to word using SpellNumber function.

Based on our requirements, like Currency, Rounded Numbers, Numbers with Decimals etc can be changed using VB functionality.

For VB Code : Try - http://support.microsoft.com/kb/213360

The alternate method to convert numbers to words is using Kutools.

Thanks and Regards

Feroz Khan Saleem

simply by spell number function nd by  cutools

Agree with all answers