I viewed the help in another posting and tried it. It solved the problem of
hainalm the decimals but I need it to dispay as 75% not 0.75.

Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"}
Souce document shows in cell 75% and is formatted as a percentage with no
decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the problem
of
hainalm the decimals but I need it to dispay as 75% not 0.75.

Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"}
Souce document shows in cell 75% and is formatted as a percentage with no
decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

Thanks for the link but I am already there and have typed exactly what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from the data may
display as 0.41354836739 when merged into Word. To display the decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and left the
rest of the formula the same. It did remove the decimals but still displays
as .75% instead of 75%. If this isn't possible can someone tell me it is or
not as I have read through the very link you gave me. I've been working on
this for a couple of hours.



"Suzanne S. Barnhill" wrote:

See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the problem
of
hainalm the decimals but I need it to dispay as 75% not 0.75.

Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"}
Souce document shows in cell 75% and is formatted as a percentage with no
decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

Personally I just use the DDE method to connect to the Excel data if I
want the formats to be included.

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your mail merge data source again
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead of
the data as it is stored.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Thanks for the link but I am already there and have typed exactly
what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from the
data may
display as 0.41354836739 when merged into Word. To display the
decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and left
the
rest of the formula the same. It did remove the decimals but still
displays
as .75% instead of 75%. If this isn't possible can someone tell me
it is or
not as I have read through the very link you gave me. I've been
working on
this for a couple of hours.

Beth I went into Tool Options and General and selected Confirm Conversion at
Open but it did not ask me anything except for how many records I wanted to
merge.
The checkis in the box for this item but its not asking me anything about a
method of conversion.

"Beth Melton" wrote:

Personally I just use the DDE method to connect to the Excel data if I
want the formats to be included.

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your mail merge data source again
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead of
the data as it is stored.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Thanks for the link but I am already there and have typed exactly
what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from the
data may
display as 0.41354836739 when merged into Word. To display the
decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and left
the
rest of the formula the same. It did remove the decimals but still
displays
as .75% instead of 75%. If this isn't possible can someone tell me
it is or
not as I have read through the very link you gave me. I've been
working on
this for a couple of hours.

Did you select your mail merge data source again? Once you have a
connection to your data source then you need to reconnect it in order
to select a different connection method.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Beth I went into Tool Options and General and selected Confirm
Conversion at
Open but it did not ask me anything except for how many records I
wanted to
merge.
The checkis in the box for this item but its not asking me anything
about a
method of conversion.

"Beth Melton" wrote:

Personally I just use the DDE method to connect to the Excel data
if I
want the formats to be included.

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your mail merge data source again
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead
of
the data as it is stored.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Thanks for the link but I am already there and have typed exactly
what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from
the
data may
display as 0.41354836739 when merged into Word. To display the
decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and
left
the
rest of the formula the same. It did remove the decimals but
still
displays
as .75% instead of 75%. If this isn't possible can someone tell
me
it is or
not as I have read through the very link you gave me. I've been
working on
this for a couple of hours.

The = (formula) field is required. Did you insert the field boundaries with
CTRL+F9 and did you update the field F9, and I hope your spelling mistake
didn't make its way into the field As you have not multiplied by 100 the
decimal is now in the wront place.

{={Mergefield Amount} * 100 \# "0%"}


--

Graham Mayor - Word MVP

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




Roberta wrote:
Thanks for the link but I am already there and have typed exactly
what it staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from the
data may display as 0.41354836739 when merged into Word. To display
the decimal as a percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and left
the
rest of the formula the same. It did remove the decimals but still
displays as .75% instead of 75%. If this isn't possible can someone
tell me it is or not as I have read through the very link you gave
me. I've been working on this for a couple of hours.



"Suzanne S. Barnhill" wrote:

See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the
problem of hainalm the decimals but I need it to dispay as 75% not
0.75.

Here's what I have in Word 2003 document: {MERGEFIELD
"Van"*100\#"0%"} Souce document shows in cell 75% and is formatted
as a percentage with no decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

Thank you soooooooo very much. Often I do read the articles, but its
nothiong like ole fashion step by step answers! Have a blessed week.

"Beth Melton" wrote:

Did you select your mail merge data source again? Once you have a
connection to your data source then you need to reconnect it in order
to select a different connection method.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Beth I went into Tool Options and General and selected Confirm
Conversion at
Open but it did not ask me anything except for how many records I
wanted to
merge.
The checkis in the box for this item but its not asking me anything
about a
method of conversion.

"Beth Melton" wrote:

Personally I just use the DDE method to connect to the Excel data
if I
want the formats to be included.

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your mail merge data source again
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead
of
the data as it is stored.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Roberta" wrote in message
...
Thanks for the link but I am already there and have typed exactly
what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from
the
data may
display as 0.41354836739 when merged into Word. To display the
decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and
left
the
rest of the formula the same. It did remove the decimals but
still
displays
as .75% instead of 75%. If this isn't possible can someone tell
me
it is or
not as I have read through the very link you gave me. I've been
working on
this for a couple of hours.

If you enter the calculated field as follows Crl F9 to obtain the first {}
then type = between the bracket followed by another Crl F9 {={}} next type
MERGEDFIELD Amount between the enclosed brackets. followed by * 100 \#"0%.
It important you don't input the brackets from the keyboard Hope this is
some help
Bob Fortune
See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the problem
of
hainalm the decimals but I need it to dispay as 75% not 0.75.

Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"}
Souce document shows in cell 75% and is formatted as a percentage with no
decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

You have a typo there Bob - it should be MERGEFIELD.

--

Graham Mayor - Word MVP

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


Bob Fortune wrote:
If you enter the calculated field as follows Crl F9 to obtain the
first {} then type = between the bracket followed by another Crl F9
{={}} next type MERGEDFIELD Amount between the enclosed brackets.
followed by * 100 \#"0%. It important you don't input the brackets
from the keyboard Hope this is some help
Bob Fortune
See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the
problem of hainalm the decimals but I need it to dispay as 75% not
0.75.

Here's what I have in Word 2003 document: {MERGEFIELD
"Van"*100\#"0%"} Souce document shows in cell 75% and is formatted
as a percentage with no decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

cheers Graham i should have read your reply as you have already given the
solution.

"Graham Mayor" wrote:

You have a typo there Bob - it should be MERGEFIELD.

--

Graham Mayor - Word MVP

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


Bob Fortune wrote:
If you enter the calculated field as follows Crl F9 to obtain the
first {} then type = between the bracket followed by another Crl F9
{={}} next type MERGEDFIELD Amount between the enclosed brackets.
followed by * 100 \#"0%. It important you don't input the brackets
from the keyboard Hope this is some help
Bob Fortune
See http://homepage.swissonline.ch/cindy...002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

"Roberta" wrote in message
...
I viewed the help in another posting and tried it. It solved the
problem of hainalm the decimals but I need it to dispay as 75% not
0.75.

Here's what I have in Word 2003 document: {MERGEFIELD
"Van"*100\#"0%"} Souce document shows in cell 75% and is formatted
as a percentage with no decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?