Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Mohd Asif Ansari , HR Administrator , Al Nasseej Al Arabi Factory Co. Ltd.
Date Posted: 2014/06/10
Anu Menon
by Anu Menon , Reservation Team Leader , Premier Inn Abu Dhabi

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

Feroz Khan
by Feroz Khan , Project Manager (Online Marketing) , Business Technology Management Inc.

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

Zeeshan Ahmad Ali
by Zeeshan Ahmad Ali , Asst. Mechanical Engineer & Site Supervisor, QA/QC , SHEIKHOO SUGAR MILLS LTD

simply by spell number function nd by  cutools

Zubair Jahangir
by Zubair Jahangir , Cost Accountant , Rotana Hotels

Agree with all answers

More Questions Like This