View Single Post
  #3   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 Why doesn't money sign show in mail merge?

Excel does not actually store the number with the dollar sign and Word only
sees the information in the way that it is stored in Excel.

To see how to format currency fields, see the "Formatting Word fields with
switches" item 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, originally posted via msnews.microsoft.com
"Dressmaker" wrote in message
...
When I merge my database (using Excel) the money appears as text. How do
I
get the money to appear with the money sign?