mail merge and excel data

[sherobot]

I have an excel sheet that has numbers calculated on it and I'm bringing
those numbers into a word doc by using a mail merge. Does anyone know how to
make the numbers have the correct formatting (i.e. $12,876.00) once it merges?
Or can you tell me how to change the formatting using fields once the data
has been merged?
Thanks

 

[Peter Jamieson]

Usually you can use Alt-F9 to display the field code, e.g.

{ MERGEFIELD myamount \*Mergeformat }

and add a numeric "format switch", e.g.

{ MERGEFIELD myamount \#"$,0.00" \*Mergeformat }

Then Alt-F9 again to reveal the result, and if necessary, slect the field
and press F9 to update it.

Peter Jamieson

 

[sherobot]

That worked great, thank you!

Usually you can use Alt-F9 to display the field code, e.g.

{ MERGEFIELD myamount \*Mergeformat }

and add a numeric "format switch", e.g.

{ MERGEFIELD myamount \#"$,0.00" \*Mergeformat }

Then Alt-F9 again to reveal the result, and if necessary, slect the field
and press F9 to update it.

Peter Jamieson