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

[cloparo]

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

 

[Doug Robbins - Word MVP]

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

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


--
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

 

[Peter Jamieson]

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

 

[cloparo]

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

 

[cloparo]

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


--
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