© Roy Cox (2005 - 2020)

.

Display numbers as words in Excel.

Have you ever needed to display numbers as text, like when writing a cheque, receipt or an invoice? Currently, there is no function in Excel that will do this. There are several versions of a User Defined Function to convert a numeric value to Text available. This is one that I adapted to allow the user to specify a Currency to display in the result.

How to use the NumToText UDF

It’s not difficult to use, download the example workbook to see some examples of how to use the function and experiment with it. The syntax for the NumToText function is: NumToText( value, show currency, "currency") value: This is the number to convert, it could be a Cell value or entered as a number show currency: This is a Boolean value, enter True to show the currency, False show as a number only with the currency. currency: This is a String Variable to be displayed. Enter your choice of currency - "pound","Euro", "US Dollar",etc. Again you could have this recorded in a cell. You can use the Function like any Excel formula. Type this in a cell =numtotext(600.47,TRUE,"dollar"), the cell will display six hundred dollars and forty seven cents. You can copy the code to your own workbook, if you aren’t sure how to do this then read how to here. Download the example workbook
Numbers To Text UDF

Page Title

Making Excel work for you.
Basic Invoice Template
If you find this article useful You can help maintain my site by donating. Simply click the image below
Buy me a coffeeBuy me a coffee

© Ut duis incididunt ex officia

.

Display numbers as words in Excel.

Have you ever needed to display numbers as text, like when writing a cheque, receipt or an invoice? Currently, there is no function in Excel that will do this. There are several versions of a User Defined Function to convert a numeric value to Text available. This is one that I adapted to allow the user to specify a Currency to display in the result.

How to use the NumToText UDF

It’s not difficult to use, download the example workbook to see some examples of how to use the function and experiment with it. The syntax for the NumToText function is: NumToText( value, show currency, "currency") value: This is the number to convert, it could be a Cell value or entered as a number show currency: This is a Boolean value, enter True to show the currency, False show as a number only with the currency. currency: This is a String Variable to be displayed. Enter your choice of currency - "pound","Euro", "US Dollar",etc. Again you could have this recorded in a cell. You can use the Function like any Excel formula. Type this in a cell =numtotext(600.47,TRUE,"dollar"), the cell will display six hundred dollars and forty seven cents. You can copy the code to your own workbook, if you aren’t sure how to do this then read how to here. Download the example workbook
Numbers To Text UDF

Page Title

Logotype