Currency format is lost during Document Merge from Excel to Word.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cloparo - 25 Jul 2006 18:26 GMT

Currency format is lost during Document Merge from Excel to Word. Why?

Reply to this Message

Doug Robbins - Word MVP - 25 Jul 2006 19:17 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Currency format is lost during Document Merge from Excel to Word. Why?

Reply to this Message

cloparo - 25 Jul 2006 19:38 GMT

Thanks, Doug.

Carmen

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
>
> http://www.gmayor.com/formatting_word_fields.htm
>
> > Currency format is lost during Document Merge from Excel to Word. Why?

Reply to this Message

Peter Jamieson - 25 Jul 2006 19:18 GMT

It's because the way Word gets data by default from Excel (OLEDB) looks at
the "underlying data" in Excel, not the "presentation" version of the data.
If you have Excel, you can revert to the old connection method (DDE) by
checking Word Tools|Options|General|"Confirm conversions at open",
reconnecting to the Excel sheet and selecting the DDE option when it is
offered. Alternatively, you may be able to format currency amounts by
changing the field code from e.g.

{ MERGEFIELD mynumber \*mergeformat }

to e.g.

{ MERGEFIELD mynumber \#"$,0.00" }

I don't like it either, but that's the way it is. This explanation and
approach to a solution has been posted hundreds if not thousands of times in
this group, yet you do not appear to have looked for it. Why?

Peter Jamieson

> Currency format is lost during Document Merge from Excel to Word. Why?

Reply to this Message

cloparo - 25 Jul 2006 19:37 GMT

Thanks, Peter.

I just upgraded our PCs recently and this is the first time it has happened.
That's why I didn't ask before - didn't know the problem existed until now!

I will try your suggestions.

Carmen

> It's because the way Word gets data by default from Excel (OLEDB) looks at
> the "underlying data" in Excel, not the "presentation" version of the data.
[quoted text clipped - 17 lines]
>
> > Currency format is lost during Document Merge from Excel to Word. Why?

Reply to this Message