DISPLAY FIELD CODES WORD 2016 SOFTWARE

This is the usual way percentages are handled in Excel.Īctual Value: exposes the value in column B in the way Excel stores it, in other words as a fraction. Percentage: Column B is the fraction (eg 0.12) displayed as a percentage. Here’s a sample worksheet that shows you two different ways to ‘massage’ a percentage into a Word friendly form (the data is fictional): The most direct option is to add some columns in Excel with versions of the percentage figure that you can use in Excel. 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. In the letter (opened in MS Word), input the merge field named “date of execution” into the letter.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. Then, you will find that the date will be formatted and shown in a new form. Select cell E2 and input the following formula:įor your information, the aforesaid date data belongs to a column named “date of execution”, expressly as follows:

), and (ii) cell E2 will contain the result of the new format. I assume that (i) cell A2 contains the date data that you wish to format (e.g. Correction date data as text with new format I think that we would correct it as text from the Excel file. For month, it is capital m (M) that you should use. Remember: “m” is used for minutes in a date field. For example, you can write “MMM d yyyy” to format date like Aug 5 2013. Now add the date format switch after field name in the following fashion:Ĭlick OK and the format of your field should get changed to the one whose switch you’ve just used.Įxample of date “dddd, d MMMM yyyy” (formats like: Monday, 5 August “ddd, d MMMM yyyy” (formats like: Mon, 5 August “d MMM yyyy” (formats like: 5 Aug “dd/MMM/yyyy” (formats like: 05/Aug/2013)īesides these, you can create any of your desired codes by rearranging these switches (d, M and y). If there is anything after the field name, just delete that. Where MyDate is the name of your date field (so it could be different in your case) It would be something like:Īlso Read: See more of MS-Word Tips and Trick

Now you will see a box containing field codes of the date field in question.

Take right click on it and select “ Edit Field…” from the pop-up menuĪ box will appear. Select the date field that you have inserted in your document. But, thankfully, we can change the format of date to suit your purpose. When you do Mail Merge and if you are using a date field of mergeformat, sometimes MS-Word picks date field from source and prints it in an unwanted format. Suppose you want to print one thousand letters wherein the letter text remains same but recipient name and address and date changes every time in such a scenario, mail merge comes to your rescue. For this the Mail Merge feature of MS Word is used.

DISPLAY FIELD CODES WORD 2016 SOFTWARE

MS-Word, the word processing software from Microsoft Corporation is often used by individuals and institutions to create and print personalized letters in large quantities.

Display field codes word 2016