Edit merged excel data

Using Excel and Word 2002, Excel cells formatted in currency with 2 decimal
places merge into Word displaying 14 decimal places. How can I truncate the
14 to 2?

Graham
Fri Dec 31 10:44:42 CST 2004

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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


Dick Williams wrote:
> Using Excel and Word 2002, Excel cells formatted in currency with 2
> decimal places merge into Word displaying 14 decimal places. How can
> I truncate the 14 to 2?

TF
Fri Dec 31 11:31:35 CST 2004

Dick

An alternative is to change the behaviour in Excel for the SS you are using.
By Default, Excel only displays the number of decimal place you set (2 by
default): however, underneath it keeps all decimal places for accuracy.
Under Tools, Options, Calculation tab, you can check the Precision as
Displayed option. This will export as seen. However, if this is a complex
SS, checking this option may produce inaccurate results.

--
Terry Farrell - Word MVP
http://word.mvps.org/

"Dick Williams" <Dick Williams@discussions.microsoft.com> wrote in message
news:4C153AA6-4A44-49B0-9AB2-393B25CD8FFA@microsoft.com...
: Using Excel and Word 2002, Excel cells formatted in currency with 2
decimal
: places merge into Word displaying 14 decimal places. How can I truncate
the
: 14 to 2?