[deb]

I've created a document that is an employee record - I'm using Excel as the
database and then mail merge to create a separate record for each Excel row.
I have pay rate information as a field. It is formatted at 00.00 ex: 8.50 in
Excel, however, when I mail merge the information comes into the Word
document as 8.5. I can't find anything on how to format a cell in a table to
the numeric format.

[Rich/rerat]

Deb,
You will need a switch to force the value from the mergefield item, to
display as you want it to in the word document.

Add the following switch:
\# "0.00" or \# "$ 0.00" (if you want to show dollar sign.

So the mergefield pay rate, would look something like this when you right
click and toggle it:
{mergefield pay_rate \# "0.00"} OR
{mergefield pay_rate \# "$ 0.00"}

Great site, created by Graham Mayor, for more information about formatting
word fields.
http://www.gmayor.com/formatting_word_fields.htm

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Deb" wrote in message
...
I've created a document that is an employee record - I'm using Excel as the
database and then mail merge to create a separate record for each Excel row.
I have pay rate information as a field. It is formatted at 00.00 ex: 8.50
in
Excel, however, when I mail merge the information comes into the Word
document as 8.5. I can't find anything on how to format a cell in a table
to
the numeric format.