Well, here we go. I have an address field that is in all upper case. If I
change it to proper case, the second letter of the state in the address will
be lower case
for ex. WEST JORDAN UT 84084
yields West Jordan Ut 84084
Any suggestions?
"mark" wrote:
Thanks again Peter for the quick response
"Peter Jamieson" wrote:
Change
{ MERGEFIELD myamount }
to
{ MERGEFIELD myamount \#"$,0.00" }
Peter Jamieson
"mark" wrote in message
...
Thank You Peter,it worked great....I have one final question if you can
help
me. A monetary amount is showing up as 92800. when I would like it to
show
up as $92,800.00. Any suggestions?
"Peter Jamieson" wrote:
With your Word document open, press Alt-F9 to see the field codes. They
look
like { MERGEFIELD mydate } rather than mydate
Then type the "format switch" text after the field name and before the
"}",
as previously suggested.
If you already have a switch that looks like "\*Mergeformat", in most
cases
it won't do any harm to delete it.
Peter Jamieson
"mark" wrote in message
...
Where do I do the date switch...Not exactly computer saavy and this is
driving me crazy. After the date is displayed in my docs, I see
12:00:00
AM
and I'd like to remove that from the docs
"Peter Jamieson" wrote:
If you formatted it using a date/time switch in Word, what switch did
you
use?
If you formatted it in Excel, do not expect Word to use the formatting
you
used - try a date switch in Word, e.g. change
{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"MM DDD YY" }
substituting whatever format you need.
There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm
Peter Jamieson
"mark" wrote in message
...
why do I get a time along with the date when I have it formatted to
only
show
a date