View Single Post
  #5   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 How can I maintain Excel's number formatting when merging to W

In exactly the same way. Alt+F9 to display the field codes and add the
appropriate formatting switch.

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

"Heidi" wrote in message
...
Does anyone know how to replicate this is Word 2007 yet?


"Doug Robbins" wrote:

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
"jenniferb" wrote in message
news
I have data in Excel that is set to automatically round to two decimal
places
and maintain currency formatting, but when I merge it into Word, that
formatting is lost. Is there a way that this number formatting can be
maintained when merged to Word?