I have a Word merge document that has worked fine for several years- at least
until I had the misfortune to upgrade to Office 2003. Now I am having to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal points.

I feel like I am back in the DOS world of 1985 - learning codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am having to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

I looked at it to format the $ fields. Can't get the calculations to work for
% fields.

I just had to gripe about what a sub-standard product MS is putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am having to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

What is wrong about what you are getting for the percent fields? What is
the entry in the datasource? What do you want to be displayed in the
document? What is now being displayed?

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

"ignatious" wrote in message
news
I looked at it to format the $ fields. Can't get the calculations to work
for
% fields.

I just had to gripe about what a sub-standard product MS is putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

The entry in my Excel worksheet is a number such as .01 formatted as %.

per gmayor's website, I tried using a formula {={MERGEFIELD rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00% or .65%
etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields? What is
the entry in the datasource? What do you want to be displayed in the
document? What is now being displayed?

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

"ignatious" wrote in message
news
I looked at it to format the $ fields. Can't get the calculations to work
for
% fields.

I just had to gripe about what a sub-standard product MS is putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted as %.

per gmayor's website, I tried using a formula {={MERGEFIELD rate_}*100 \#
#
"0%"} and various permutations thereof. I kept getting the error message
"A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an unformatted "0"
in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00% or .65%
etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields? What is
the entry in the datasource? What do you want to be displayed in the
document? What is now being displayed?

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

"ignatious" wrote in message
news
I looked at it to format the $ fields. Can't get the calculations to
work
for
% fields.

I just had to gripe about what a sub-standard product MS is putting
out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years-
at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to
get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

Sorry, I had a typo in my response. I went back and edited my merge doc to
include your formula as you have it written below and, after receiving the
invalid formla error message, got the formula in my final document instead of
x%.

The mergefield is valid because I can get it to supply a raw number in my
merge doc. My syntax matches yours - I even tried it with spaces in the
formula.

I wish the MS braintrust would leave software that works alone! I'm sorry I
'upgraded' if you want to call software that doesn't work an upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted as %.

per gmayor's website, I tried using a formula {={MERGEFIELD rate_}*100 \#
#
"0%"} and various permutations thereof. I kept getting the error message
"A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an unformatted "0"
in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00% or .65%
etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields? What is
the entry in the datasource? What do you want to be displayed in the
document? What is now being displayed?

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

"ignatious" wrote in message
news I looked at it to format the $ fields. Can't get the calculations to
work
for
% fields.

I just had to gripe about what a sub-standard product MS is putting
out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several years-
at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes to
get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

Did you insert each pair of field boundaries with CTRL+F9 as mentioned on
the web page?
The software works fine - it's the pilot who doesn't have the necessary
training to fly it!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
Sorry, I had a typo in my response. I went back and edited my merge
doc to include your formula as you have it written below and, after
receiving the invalid formla error message, got the formula in my
final document instead of x%.

The mergefield is valid because I can get it to supply a raw number
in my merge doc. My syntax matches yours - I even tried it with
spaces in the formula.

I wish the MS braintrust would leave software that works alone! I'm
sorry I 'upgraded' if you want to call software that doesn't work an
upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted
as %.

per gmayor's website, I tried using a formula {={MERGEFIELD
rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error
message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an
unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00%
or .65% etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields?
What is the entry in the datasource? What do you want to be
displayed in the document? What is now being displayed?

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

"ignatious" wrote in message
news I looked at it to format the $ fields. Can't get the calculations
to work
for
% fields.

I just had to gripe about what a sub-standard product MS is
putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in
message
...
I have a Word merge document that has worked fine for several
years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal points.

I feel like I am back in the DOS world of 1985 - learning codes
to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based
Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

You must be doing something wrong because it works fine for me with Word
2003. In your latest attempt, did you use Ctrl+F9 to insert all of the
field delimiters {}?

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

"ignatious" wrote in message
...
Sorry, I had a typo in my response. I went back and edited my merge doc to
include your formula as you have it written below and, after receiving the
invalid formla error message, got the formula in my final document instead
of
x%.

The mergefield is valid because I can get it to supply a raw number in my
merge doc. My syntax matches yours - I even tried it with spaces in the
formula.

I wish the MS braintrust would leave software that works alone! I'm sorry
I
'upgraded' if you want to call software that doesn't work an upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted as %.

per gmayor's website, I tried using a formula {={MERGEFIELD rate_}*100
\#
#
"0%"} and various permutations thereof. I kept getting the error
message
"A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an unformatted
"0"
in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00% or
.65%
etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields? What
is
the entry in the datasource? What do you want to be displayed in the
document? What is now being displayed?

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

"ignatious" wrote in message
news I looked at it to format the $ fields. Can't get the calculations to
work
for
% fields.

I just had to gripe about what a sub-standard product MS is putting
out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in message
...
I have a Word merge document that has worked fine for several
years-
at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal
points.

I feel like I am back in the DOS world of 1985 - learning codes
to
get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to
the
suggestions with the most votes. To vote for this suggestion,
click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

If I press Ctrl-f9 as suggested, I get {}. Do I have insert my merge field
between them?

The software may work correctly but being able to format a merge field is
common enough that it should be a simple matter if the software was written
well.

"Graham Mayor" wrote:

Did you insert each pair of field boundaries with CTRL+F9 as mentioned on
the web page?
The software works fine - it's the pilot who doesn't have the necessary
training to fly it!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
Sorry, I had a typo in my response. I went back and edited my merge
doc to include your formula as you have it written below and, after
receiving the invalid formla error message, got the formula in my
final document instead of x%.

The mergefield is valid because I can get it to supply a raw number
in my merge doc. My syntax matches yours - I even tried it with
spaces in the formula.

I wish the MS braintrust would leave software that works alone! I'm
sorry I 'upgraded' if you want to call software that doesn't work an
upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted
as %.

per gmayor's website, I tried using a formula {={MERGEFIELD
rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error
message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an
unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00%
or .65% etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields?
What is the entry in the datasource? What do you want to be
displayed in the document? What is now being displayed?

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

"ignatious" wrote in message
news I looked at it to format the $ fields. Can't get the calculations
to work
for
% fields.

I just had to gripe about what a sub-standard product MS is
putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in
message
...
I have a Word merge document that has worked fine for several
years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal points.

I feel like I am back in the DOS world of 1985 - learning codes
to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based
Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

Between the two brackets {}
Type =
{=}
then either insert your mergefield or better still, press CTRL+F9 again
{={}}
Between the second pair of brackets type Mergefield followed by your
fieldname exactly as it appears in the insert field dialog
{={Mergefield rate_}}
Finally add the calculation and the formatting switch
{ = { MERGEFIELD rate_ } * 100 \# "0%" }
With the cursor in the field Press F9 to update, and if the display does not
switch back on its own, ALT+F9 will switch it.
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
If I press Ctrl-f9 as suggested, I get {}. Do I have insert my merge
field between them?

The software may work correctly but being able to format a merge
field is common enough that it should be a simple matter if the
software was written well.

"Graham Mayor" wrote:

Did you insert each pair of field boundaries with CTRL+F9 as
mentioned on the web page?
The software works fine - it's the pilot who doesn't have the
necessary training to fly it!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
Sorry, I had a typo in my response. I went back and edited my merge
doc to include your formula as you have it written below and, after
receiving the invalid formla error message, got the formula in my
final document instead of x%.

The mergefield is valid because I can get it to supply a raw number
in my merge doc. My syntax matches yours - I even tried it with
spaces in the formula.

I wish the MS braintrust would leave software that works alone! I'm
sorry I 'upgraded' if you want to call software that doesn't work an
upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted
as %.

per gmayor's website, I tried using a formula {={MERGEFIELD
rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error
message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an
unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00%
or .65% etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields?
What is the entry in the datasource? What do you want to be
displayed in the document? What is now being displayed?

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

"ignatious" wrote in
message
news I looked at it to format the $ fields. Can't get the
calculations to work
for
% fields.

I just had to gripe about what a sub-standard product MS is
putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in
message
...
I have a Word merge document that has worked fine for several
years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal points.

I feel like I am back in the DOS world of 1985 - learning
codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft
responds to the
suggestions with the most votes. To vote for this suggestion,
click the
"I
Agree" button in the message pane. If you do not see the
button, follow
this
link to open the suggestion in the Microsoft Web-based
Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

I tried using alt-f9 to get the brackets in but it still wasn't giving me the
proper result. It turns out, if you use alt-f9 to display codes, it keeps
that setting when you look at the merged doc.

Thanks for the help Graham.

MS did a poor job writing this software. Something like formatting a mail
merge should be more user-friendly. A casual user shouldn't have to probe
about the internet to find how to format raw data. Office 2000 did a good job
of being user-friendly. I am sorry I upgraded to 2003.

"Graham Mayor" wrote:

Between the two brackets {}
Type =
{=}
then either insert your mergefield or better still, press CTRL+F9 again
{={}}
Between the second pair of brackets type Mergefield followed by your
fieldname exactly as it appears in the insert field dialog
{={Mergefield rate_}}
Finally add the calculation and the formatting switch
{ = { MERGEFIELD rate_ } * 100 \# "0%" }
With the cursor in the field Press F9 to update, and if the display does not
switch back on its own, ALT+F9 will switch it.
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
If I press Ctrl-f9 as suggested, I get {}. Do I have insert my merge
field between them?

The software may work correctly but being able to format a merge
field is common enough that it should be a simple matter if the
software was written well.

"Graham Mayor" wrote:

Did you insert each pair of field boundaries with CTRL+F9 as
mentioned on the web page?
The software works fine - it's the pilot who doesn't have the
necessary training to fly it!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
Sorry, I had a typo in my response. I went back and edited my merge
doc to include your formula as you have it written below and, after
receiving the invalid formla error message, got the formula in my
final document instead of x%.

The mergefield is valid because I can get it to supply a raw number
in my merge doc. My syntax matches yours - I even tried it with
spaces in the formula.

I wish the MS braintrust would leave software that works alone! I'm
sorry I 'upgraded' if you want to call software that doesn't work an
upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in message
...
The entry in my Excel worksheet is a number such as .01 formatted
as %.

per gmayor's website, I tried using a formula {={MERGEFIELD
rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error
message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an
unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is 1.00%
or .65% etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent fields?
What is the entry in the datasource? What do you want to be
displayed in the document? What is now being displayed?

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

"ignatious" wrote in
message
news I looked at it to format the $ fields. Can't get the
calculations to work
for
% fields.

I just had to gripe about what a sub-standard product MS is
putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in
message
...
I have a Word merge document that has worked fine for several
years- at
least
until I had the misfortune to upgrade to Office 2003. Now I am
having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal points.

I feel like I am back in the DOS world of 1985 - learning
codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft
responds to the
suggestions with the most votes. To vote for this suggestion,
click the
"I
Agree" button in the message pane. If you do not see the
button, follow
this
link to open the suggestion in the Microsoft Web-based
Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

You insert the field brackets with CTRL+F9
ALT+F9 is a toggle setting between the field construction and the result.
Press it again!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
I tried using alt-f9 to get the brackets in but it still wasn't
giving me the proper result. It turns out, if you use alt-f9 to
display codes, it keeps that setting when you look at the merged doc.

Thanks for the help Graham.

MS did a poor job writing this software. Something like formatting a
mail merge should be more user-friendly. A casual user shouldn't have
to probe about the internet to find how to format raw data. Office
2000 did a good job of being user-friendly. I am sorry I upgraded to
2003.

"Graham Mayor" wrote:

Between the two brackets {}
Type =
{=}
then either insert your mergefield or better still, press CTRL+F9
again {={}}
Between the second pair of brackets type Mergefield followed by your
fieldname exactly as it appears in the insert field dialog
{={Mergefield rate_}}
Finally add the calculation and the formatting switch
{ = { MERGEFIELD rate_ } * 100 \# "0%" }
With the cursor in the field Press F9 to update, and if the display
does not switch back on its own, ALT+F9 will switch it.
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
If I press Ctrl-f9 as suggested, I get {}. Do I have insert my merge
field between them?

The software may work correctly but being able to format a merge
field is common enough that it should be a simple matter if the
software was written well.

"Graham Mayor" wrote:

Did you insert each pair of field boundaries with CTRL+F9 as
mentioned on the web page?
The software works fine - it's the pilot who doesn't have the
necessary training to fly it!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ignatious wrote:
Sorry, I had a typo in my response. I went back and edited my
merge doc to include your formula as you have it written below
and, after receiving the invalid formla error message, got the
formula in my final document instead of x%.

The mergefield is valid because I can get it to supply a raw
number in my merge doc. My syntax matches yours - I even tried it
with spaces in the formula.

I wish the MS braintrust would leave software that works alone!
I'm sorry I 'upgraded' if you want to call software that doesn't
work an upgrade.

Thanks for the help.

You have an extra # in your field.construction

It should be { = { MERGEFIELD rate_ } * 100 \# "0%" }

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

"ignatious" wrote in
message
...
The entry in my Excel worksheet is a number such as .01
formatted as %.

per gmayor's website, I tried using a formula {={MERGEFIELD
rate_}*100 \# #
"0%"} and various permutations thereof. I kept getting the error
message "A
field calculation error occurred in record 1".

Without the formula I didn't get the error butr I got an
unformatted "0" in
my document.

What I want to get (and what I got when I used Word 2000) is
1.00% or .65% etc.

"Doug Robbins - Word MVP" wrote:

What is wrong about what you are getting for the percent
fields? What is the entry in the datasource? What do you want
to be displayed in the document? What is now being displayed?

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

"ignatious" wrote in
message
news I looked at it to format the $ fields. Can't get the
calculations to work
for
% fields.

I just had to gripe about what a sub-standard product MS is
putting out.

"Doug Robbins - Word MVP" wrote:

You may already know this, but 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

"ignatious" wrote in
message
...
I have a Word merge document that has worked fine for
several years- at
least
until I had the misfortune to upgrade to Office 2003. Now I
am having
to
learn about switches to format data as dollars.

Word doesn't talk to Excel anymore???????????

I still can't get my percetnages to show up, with or without
decimal points.

I feel like I am back in the DOS world of 1985 - learning
codes to get
documents to print.

----------------
This post is a suggestion for Microsoft, and Microsoft
responds to the
suggestions with the most votes. To vote for this
suggestion, click the
"I
Agree" button in the message pane. If you do not see the
button, follow
this
link to open the suggestion in the Microsoft Web-based
Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds