Percentage - normally, appears as a decimal number corresponding to the percent in some cases - a floating-point number.In Word, a number in its pure form is displayed (3000). In Excel, the number is formatted as Currency ($3,000.00). Currency - appears without the currency symbol, thousands separator, and decimal places.In Word, an underlying value (2451) shows up. In Excel, a leading zero is displayed because a cell has a custom number format such as 00000. Zip code - appears without a leading zero.Now, see what happens in a Word mail merge document: To illustrate the problem, please have a look at the source data formats in an Excel worksheet: As a result, in a Word document, the data appears in the format in which it is stored internally in Excel, and not in the format applied to cells. The problems typically occur with numbers formatted as percentage or currency, or numbers containing leading zeros such as zip codes.Ĭause: By default, Microsoft Word uses the OLE DB connection, which pulls in the information but not formats. When performing a mail merge from an Excel worksheet, some of your numeric data may lose formatting after coming through the merge.
0 Comments
Leave a Reply. |