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

Apply numeric formats in Word

From the course: Word: Mail Merge in Depth

Start my 1-month free trial

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…

Contents