Word/Excel merge, # format incorrect (i.e. $(2.00) instead of 2.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maryi - 18 Nov 2006 19:33 GMT

Just bought Toshiba laptop. Trying to merge word letter w/excel spreadsheet.
I can't get the number format I want to merge into word document. Example,
it is transferring the number 1 instead of 1.00. Also for negative number
showing "-1" instead of (1). Any suggestions? Thanks.

Reply to this Message

Doug Robbins - Word MVP - 18 Nov 2006 20: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

> Just bought Toshiba laptop. Trying to merge word letter w/excel
> spreadsheet.
> I can't get the number format I want to merge into word document.
> Example,
> it is transferring the number 1 instead of 1.00. Also for negative number
> showing "-1" instead of (1). Any suggestions? Thanks.

Reply to this Message