How Do You Insert The Spell Number In Excel

Checking spellings in excel is very easy.

How do you insert the spell number in excel. We at exceldatapro have created spellnumber excel function for 6 currencies in one code. Spell out currency numbers to english words in excel. Follow the below steps to perform a spell check in excel.

Alternatively you can also use the concatenate function to apply this formula to specific cells though this method is a bit more complicated. Press alt f11 to open the visual basic editor window. If you have several books opened check that the needed workbook is active using the list of projects in the upper left corner of the editor one of the workbook elements is highlighted with blue.

Open word and type a decimal number such as 5 67. The spellnumber for word dialog box displays. Copy paste code from this link https goo gl 6wthrn.

Spellnumber is an excel function which helps you. Click insert module and paste the following macro in the module window. In the review tab there is an option spelling as shown in the image.

In the select a function list select spellnumber followed by ok. Hold down the alt f11 keys and it opens the microsoft visual basic for applications window. Next enter the number or cell reference that you want and then click ok.

Select spellnumber from the popup menu. Press alt f11 to open the visual basic editor. Highlight the number and right click on the selection.