Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jerry
 
Posts: n/a
Default Formatting Field In Mail-Merge


I have a Word document that uses excel as the data source. I need to
display zeros in the some of the fields and number with commas in those
same fields. I used the sitch \###,###,###,###. The numbers worked fine
but my zeros didn't come thru.

Any help would be greatly appreciated.

Thanks...

J...


--
Jerry
  #2   Report Post  
RyanP
 
Posts: n/a
Default


I am having this same problem with Access. I have a currency amount of
$900.00 that I want to come over exactly like that, but it just comes
over as 900. I tried what Jerry discussed with the switch (I used
\###,###.##) but I only got 900. back (it added the decimal). This is
so frustrating! Anybody have any thoughts??? Thanks!
Ryan


Jerry Wrote:
I have a Word document that uses excel as the data source. I need to
display zeros in the some of the fields and number with commas in those
same fields. I used the sitch \###,###,###,###. The numbers worked fine
but my zeros didn't come thru.

Any help would be greatly appreciated.

Thanks...

J...



--
RyanP
  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

I am having this same problem with Access. I have a currency amount of
$900.00 that I want to come over exactly like that, but it just comes
over as 900. I tried what Jerry discussed with the switch (I used
\###,###.##) but I only got 900. back (it added the decimal). This is
so frustrating! Anybody have any thoughts??? Thanks!
Ryan


Jerry Wrote:
I have a Word document that uses excel as the data source. I need to
display zeros in the some of the fields and number with commas in those
same fields. I used the sitch \###,###,###,###. The numbers worked fine
but my zeros didn't come thru.

Any help would be greatly appreciated.

Thanks...

J...



--
RyanP



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
Mail merge field different in datasource & insert a field menu Silvs Mailmerge 1 April 22nd 05 06:18 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Formatting a percentage mail merge field Kylor Microsoft Word Help 5 March 18th 05 07:04 PM
How to remove unwanted formatting in mail merge for cells witn no Jim Mailmerge 3 March 4th 05 08:13 AM
formatting percent field using mail merge PamWilhite Mailmerge 3 February 19th 05 08:58 AM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Word"