You would like to write numbers in full letters in Excel, but you want to save time or you are not sure of spelling (dash or not, variable-invariable …) .Thanks to Excel, you will be able to almost automatically convert any number. Finally almost, up to 999999 to convert numbers to all numbers.
Convert a number to words with “Text” Function
If you are used to Microsoft Excel formulas, you can convert numbers in cells to text with the text function.If you just want to convert the number to unformatted text, you can use the formula: = Text (A1, “0”);
If you want to display the numeric zero, you can use this formula: = Text (A1, “0000”); as convert 23 to 0023.
Convert number to words with Format Cells Command
The Microsoft Excel Format Cell command also allows you to convert number to words
- Select the numbers you want to convert to text.
- Right-click on the selected range and choose the Format cell item from the context menu.
- In the Format Cell dialog box, select Text in the Category box under the Number tab and click the OK button.
We must say that there are as many squares as there are numbers.
Using online converter tools
If you are not familiar with Excel Function it would be easier for you to convert the numbers to text with this online convert tools.
This tool helps you quickly specify a number and convert it in words in few seconds so you can paste it to your worksheet and allows you to learn the spelling rules on numbers and to check the spelling of a number, when you have a doubt.