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

[maryi]

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.

 

[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