Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dressmaker Dressmaker is offline
external usenet poster
 
Posts: 1
Default Why doesn't money sign show in mail merge?

When I merge my database (using Excel) the money appears as text. How do I
get the money to appear with the money sign?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Scott M.[_2_] Scott M.[_2_] is offline
external usenet poster
 
Posts: 49
Default Why doesn't money sign show in mail merge?

Dollar amounts don't get dollar signs by default. That is just a formatting
issue. If you have a currency amount coming out of a mail merge, simply
type the dollar sign just before the merge field.

-Scott

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



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


  #4   Report Post  
Aglae Grimes Aglae Grimes is offline
Junior Member
 
Posts: 1
Default

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Table-Automatically show a $ in the money column? Charitychic Tables 6 April 5th 21 04:45 AM
working without the hide/show sign on word 2003 ajax2008 Microsoft Word Help 1 June 13th 08 01:37 AM
How do i set up mail merge to show from field ? rion Mailmerge 3 November 29th 06 04:34 AM
Help on Mail Merge just only Show One Record Alan Tang Mailmerge 2 February 21st 06 10:57 AM
Mail Merge(for emails) should have a sign before sending Xiuping Mailmerge 1 February 7th 06 07:27 AM


All times are GMT +1. The time now is 08:46 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"