EASY Mail Merge - I want Excel's Zero values to appear as $0 not b

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HTC - 28 Oct 2005 20:01 GMT

I am using Word 2003 to perform a mail merge from values on an Excel 2003
spreadsheet. For a specific Excel cell that has a value of $0, the merge is
leaving this as a BLANK after the merge is complete. I would like it to show
a $0.

Thanks,
Paul

Reply to this Message

Doug Robbins - Word MVP - 28 Oct 2005 21:04 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

>I am using Word 2003 to perform a mail merge from values on an Excel 2003
> spreadsheet. For a specific Excel cell that has a value of $0, the merge
[quoted text clipped - 5 lines]
> Thanks,
> Paul

Reply to this Message