Remember to press Ctrl + F9 to make the field – not the curly brackets on the keyboard. This lets you multiply the number coming from Excel by 100 before formatting.
To do it embed the MERGEFIELD inside another Word field.
You can change the decimal fraction (eg 0.738) to a percentage (73.8) in Word. Normally, a Word mail merge will import the raw number from Excel and let you format it in way we’ve described before.Īs usual, there’s more than one solution to the problem: Formatting in Word For example 25% is stored in Excel as 0.25. How can you put percentages into a Word mail merge?įollowing our article on importing Excel data into a Word mail merge, here are the options for using percentages.Įxcel might show a percentage but the number stored is a fraction. Thanks for joining us! You'll get a welcome message in a few moments.
