View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word/Excel merge, # format incorrect (i.e. $(2.00) instead of 2.

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

"maryi" wrote in message
...
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.