From the course: Word: Mail Merge in Depth
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Apply numeric formats in Word
From the course: Word: Mail Merge in Depth
Apply numeric formats in Word
- [Instructor] This is an event sales report that connects to a data source called an Event Sales Summary in Excel Workbook. Both of these are found in the exercise files in chapter two. This report shows data for a sales person for a row from an Excel spreadsheet. And if we look at numbers like meeting sales and percentage of international sales, we expect the meeting sales to be formatted as currency and the international sales to be formatted as a number that's something other than ridiculous in terms of it's length. I wonder if this is what it looks like in the data source. And the answer is no but let me show you as well. Here's the data source and everything here looks good. The sales numbers, currency, the percents. So how did this happen? This isn't something we can fix here because it's not broken here. It looks just fine. The problem is when we see these numbers in Excel, Excel is applying a format, makes 'em…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Match fields from the data source3m 56s
-
Insert address blocks, greeting lines, and merge fields4m 51s
-
Simulate the merge2m 47s
-
Complete the merge4m 4s
-
Open a mail merge primary document2m 29s
-
Troubleshoot mail merge5m 23s
-
Fix numeric formatting in the data source3m
-
Apply numeric formats in Word4m 24s
-
Apply date formats in Word1m 23s
-
-
-
-
-