Register now or log in to join your professional community.
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
The above answers could be used, but keeping it simple since the actual purpose is not clear, one option is the Text function. This enables you to display the text in the format you need (just to a search in excel help for the formats types).
