How To Convert Number To Words In Excel Using Formula Printable Use spellnumber macro in your worksheets. now you can use the function spellnumber in your excel documents. enter =spellnumber(a2) into the cell where you need to get the number written in words. here a2 is the address of the cell with the number or amount. here you can see the result:. Add leading apostrophe. to do this, select the cell in question and press the f2 key to enter cell editing mode. click on the first character to the left of the value and add the apostrophe symbol. number to text using apostrophe. hit enter and excel shall automatically convert your number to text in no time.
How Do I Convert Numbers To Words In Excel Automatically Formula Numbers to words converter in excel. Method 3 – using format cells. go to the format cells dialog box (press ctrl 1). under the number tab, choose the text category and click ok. all selected numbers will be converted to text. method 4 – using text to columns wizard. select the target numbers. go to the data tab and click on text to columns. Method #2 – use the ‘format cells’ option. this is a quick and easy method for converting a block of cells: select the cells containing the numbers. right click and choose “format cells…” (or press ctrl 1). in the “format cells” window, under the “number” tab, select “text” from the category list. click “ok”. Here’s how you can do it: step 1: type the number. type the number you want to convert to text in a cell. step 2: input the formula. type the following formula into another cell: =text (a1,”spelled out”). replace “a1” with the cell containing the number that you want to convert, and “spelled out” with the format you want.
Comments are closed.