Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 10, 06:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 12
Default Merging worksheet into MS Word mail merge

I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
this problem?

--
Briggs

  #2   Report Post  
Old January 7th 10, 06:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default Merging worksheet into MS Word mail merge

Hi

Instead of just referring to the cell e.g. A1 use
=TEXT(A1,"[$$-409]#,##0.00")

--
Regards
Roger Govier

"Briggs" wrote in message
...
I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $
and
the , do not show up in the merged letter. Any suggestions on how to solve
this problem?

--
Briggs

__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com



  #3   Report Post  
Old January 7th 10, 10:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Merging worksheet into MS Word mail merge

You can format the fields at the Word end of the operation.

http://office.microsoft.com/en-us/wo...164951033.aspx

But may be easier to use the TEXT function and helpers cells as Biff points
out.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 10:00:01 -0800, Briggs
wrote:

I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
this problem?


  #4   Report Post  
Old January 7th 10, 10:23 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Merging worksheet into MS Word mail merge

Error in post.

Roger........not Biff


Gord

On Thu, 07 Jan 2010 14:22:45 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

You can format the fields at the Word end of the operation.

http://office.microsoft.com/en-us/wo...164951033.aspx

But may be easier to use the TEXT function and helpers cells as Biff points
out.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 10:00:01 -0800, Briggs
wrote:

I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
this problem?


  #5   Report Post  
Old January 7th 10, 11:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default Merging worksheet into MS Word mail merge

No probs, Gord.
I hope that all is well with you, and best wishes for 2010

--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Error in post.

Roger........not Biff


Gord

On Thu, 07 Jan 2010 14:22:45 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

You can format the fields at the Word end of the operation.

http://office.microsoft.com/en-us/wo...164951033.aspx

But may be easier to use the TEXT function and helpers cells as Biff
points
out.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 10:00:01 -0800, Briggs

wrote:

I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $
and
the , do not show up in the merged letter. Any suggestions on how to
solve
this problem?



__________ Information from ESET Smart Security, version of virus
signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com





  #6   Report Post  
Old January 7th 10, 11:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Merging worksheet into MS Word mail merge

Thanks for the greetings.

Good year so far although the golf is a little sparse.

Too many frost delays.


Gord

On Thu, 7 Jan 2010 23:32:04 -0000, "Roger Govier"
<[email protected] wrote:

No probs, Gord.
I hope that all is well with you, and best wishes for 2010


  #7   Report Post  
Old January 8th 10, 12:04 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 293
Default Merging worksheet into MS Word mail merge

Hi Briggs,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.


--
Cheers
macropod
[Microsoft MVP - Word]


"Briggs" wrote in message ...
I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
this problem?

--
Briggs




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge two excel files like in word mail merge azmerritt Excel Discussion (Misc queries) 1 December 11th 16 09:23 PM
How to do mail merge from excel worksheet to word document. hiron Excel Discussion (Misc queries) 1 November 13th 07 10:24 PM
Mail Merging from Excel 2000 to Word 2003 Legal Learning Excel Discussion (Misc queries) 1 October 31st 06 06:41 PM
Mail Merging: From Filtered data to Word Rob Excel Discussion (Misc queries) 2 September 8th 06 04:23 AM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017