How to convert a number into word in ms-excel 2007 and 2010? example: 789

Question added by Mohd Asif Ansari , HR Administrator , Al Nasseej Al Arabi Factory Co. Ltd.
Date Posted: 2014/06/10

Upvote (4) Views (20) Followers (8) Answers (4) Report Question

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

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

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

simply by spell number function nd by cutools

by Zubair Jahangir , Cost Accountant , Rotana Hotels

Agree with all answers

How to send multiple emails at once from outlook by using ms-excel?
Top Answer: For example if you want send your cover letter to multiple recipient (Cont ... See More

Answers (6)
How to add Calender in drop down menu in MS Excel?
Top Answer: We can insert it by following the Steps below: Step1 &l ... See More

Answers (5)
What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... See More

Answers (154)
What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... See More

Answers (154)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

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