Convert Numeric Values to Words into MS Excel

Here are some simple steps to convert your numeric values to words in MS Excel.

In MS Excel, Go to File menu and Click “Options”

FIle Menu, Options

Click on “Customize Ribbon” on Left menu

Customize Ribbon

Under “Main Tabs” Check the box “Developer”

Developer Checkbox

Click “OK”

Proceed

You can see “Developer” Tab in Ribbon

Developer Tab

In “Developer” tab, Click “Visual Basic”

Visual Basic

In appeared view, Go to “Insert” menu and Click “Module”

Create Module

Copy the Code from Here and Paste in Module sheet

Copy and Paste Code

Exit the Visual Basic and Revert to Excel Sheet, Type the Formula in resulting cell. For Example =SpellNumber(A1)

Formula SpellNumber

You can copy the formula to other cells

Result

 

Be the first to comment

Leave a Reply

Your email address will not be published.


*