Merging from Excel data into Word gives incorrect amount
 

Hi!
When I do a merge into Word from data held in an Excel spreadsheet, the
amount gets translated from its Excel form of, say, 10.95, into the form of
10.95000000008 in the merged document. I've tried setting the "precision as
displayed" option but this hasn't helped. Any ideas anyone please?
Thanks!

Carmel

Merging from Excel data into Word gives incorrect amount
 

You can format your data on the Word side by editing the fields that get
numeric values and adding the proper switch and/or formatting mask.

For example:

To display the number "34987.89" as "$34,987.89," add a numeric picture
switch (\# $#,###.00).

To display the number "0945" as "9:45 PM," add the date/time picture switch
(\@ "h:mm am/pm").

To ensure that the merged information has the same font and point size you
apply to the merge field, add the \* MERGEFORMAT switch.

In Word's Help facility look up the topic "Format merged Data" for
additional information regarding the formatting of merged fields.


--
Kevin Backmann


"Carmel R" wrote:

Hi!
When I do a merge into Word from data held in an Excel spreadsheet, the
amount gets translated from its Excel form of, say, 10.95, into the form of
10.95000000008 in the merged document. I've tried setting the "precision as
displayed" option but this hasn't helped. Any ideas anyone please?
Thanks!

Carmel

Merging from Excel data into Word gives incorrect amount
 

AHA!!!
Thanks Kevin - that's really helpful!
Carmel


"Kevin B" wrote:

You can format your data on the Word side by editing the fields that get
numeric values and adding the proper switch and/or formatting mask.

For example:

To display the number "34987.89" as "$34,987.89," add a numeric picture
switch (\# $#,###.00).

To display the number "0945" as "9:45 PM," add the date/time picture switch
(\@ "h:mm am/pm").

To ensure that the merged information has the same font and point size you
apply to the merge field, add the \* MERGEFORMAT switch.

In Word's Help facility look up the topic "Format merged Data" for
additional information regarding the formatting of merged fields.


--
Kevin Backmann


"Carmel R" wrote:

Hi!
When I do a merge into Word from data held in an Excel spreadsheet, the
amount gets translated from its Excel form of, say, 10.95, into the form of
10.95000000008 in the merged document. I've tried setting the "precision as
displayed" option but this hasn't helped. Any ideas anyone please?
Thanks!

Carmel

Merging from Excel data into Word gives incorrect amount
 

An alternative on the Excel side is a helper column with a formula such as
=TEXT(A1,"0.00")
--
David Biddulph

"Kevin B" wrote in message
...
You can format your data on the Word side by editing the fields that get
numeric values and adding the proper switch and/or formatting mask.

For example:

To display the number "34987.89" as "$34,987.89," add a numeric picture
switch (\# $#,###.00).

To display the number "0945" as "9:45 PM," add the date/time picture
switch
(\@ "h:mm am/pm").

To ensure that the merged information has the same font and point size you
apply to the merge field, add the \* MERGEFORMAT switch.

In Word's Help facility look up the topic "Format merged Data" for
additional information regarding the formatting of merged fields.

"Carmel R" wrote:

Hi!
When I do a merge into Word from data held in an Excel spreadsheet, the
amount gets translated from its Excel form of, say, 10.95, into the form
of
10.95000000008 in the merged document. I've tried setting the "precision
as
displayed" option but this hasn't helped. Any ideas anyone please?
Thanks!

Carmel