We can convert numbers to words in Excel with UDF function SpellNumber, but we also have a method to convert the numbers to words in Microsoft WORD without any VBA code with two different methods for mac & windows
Method 01 – windows users
- Keep the cursor where you like to insert the number in words.
- In the Ribbon Go to > Insert > Quick Parts > Field…
- Field dialog box will open & click on Field Codes
- In the formula area, enter the number you like to change to the words as shown in the below figure and then click OK.
We have the our value converted from number to text
W 😮 W !! this is amazing, but we have a slight issue with the formatting as they are in lower case which we will see at the end of the post.
Method 01 – mac users
In the WORD for mac it work exactly the same.
- Keep the cursor where you like to insert the number in words.
- In the Ribbon Go to > Insert > Insert Field
- Field dialog box will open, enter the number we like to convert to words.
- Click on OK.
- We are done the number is converted to text.
Method 02 – Shortcut
- To add the Field press
- ⌘ + fn + F9 Word for Mac
- ctrl + F9 Word of Windows
- The Field will be activated now and between the curly brackets { } insert = sign and the number that to be converted into text.
- Then press backslash “\” and write *CardText.
- Press to convert your number to text.
- mac users press fn + F9
- windows users press F9
Example: Below Expression will convert 4057.15 into “four thousand and fifty-seven”
{=4057.15\*CardText}
Formatting
Formatting issue No worries, we can handle the situation as well and set the different sentence case just reconstructing our formula applicable for both mac and windows
- =4057\*CardText\*Caps capitalizes the first letter of each word.
- =4057\*CardText\*FirstCap capitalizes the first letter of the first word.
- =4057\*CardText\*Upper capitalizes on all letters.
- =4057\*CardText\*Lower capitalizes none of the results; all letters are lowercase.
⚠️ Things to note 📝
- The code “cardtext” is not case sensitive
- The value should be less than One Million (1,000,000)
- The decimal number will be rounded to the closet decimal value (Eg.: 21.49 will convert to 21)
- Work with a positive number only.
Check out the video with some more amazing examples.
Video
Subscribe to YouTube Channel for Exciting Tips & Tricks On Office Applications
Was the information helpful in this blog?
- If yes, hit that share button and show the excitement to the world.
- Subscribe to our free posts.
If no, please let us know what to improve.
Having trouble with any Office Apps. Feel free to ask and answer queries at our forums section.