[mdj0615]

I'm not sure if this question should be in word or excel forums, so let me
know. I have created a spreadsheet that pulls data from an excel sheet to
complete the merge. One of the cells that transfers over is a formula that
calculates a score. I want the merge to show the number that's in the cell.
The cells are formatted to show through one decimal space. When I merge
over, it shows the entire number that excel calculates. I can't figure out
if I need to change the excel cells, or the word merge document to just show
the numbers through the first decimal. Any help would be great. If you need
the formula to see where to put it it's:

=IF('MidMod Grades+Att.'!H3="","",'MidMod Grades+Att.'!H3)

Thank you for any help.

[Doug Robbins - Word MVP]

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,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"mdj0615" wrote in message
...
I'm not sure if this question should be in word or excel forums, so let me
know. I have created a spreadsheet that pulls data from an excel sheet to
complete the merge. One of the cells that transfers over is a formula
that
calculates a score. I want the merge to show the number that's in the
cell.
The cells are formatted to show through one decimal space. When I merge
over, it shows the entire number that excel calculates. I can't figure
out
if I need to change the excel cells, or the word merge document to just
show
the numbers through the first decimal. Any help would be great. If you
need
the formula to see where to put it it's:

=IF('MidMod Grades+Att.'!H3="","",'MidMod Grades+Att.'!H3)

Thank you for any help.