Excel Data Merged to Word - Decimals Don't Match

[Alice]

I am using Office XP - I have a simple spreadsheet in Excel - I merge the data into a table in Word, but SOME the numbers on the original Excel document come out as a different decimal setting once merged into Word. I have tried all the obvious formatting options in Excel and Word and cannot get the decimal places to match. For exaple: $.08 in Excel merges into Word as $.0829 (the field that has the $.08 has a formula result - the formula takes another number and divides it by 7 - the wrong decimals all occur on these formula cells). This has happened on more than one occasion to me and a co-worker and neither one of us can figure it out! Please help!

 

[Charlie]

Your problem may be simple to solve. Use the rounding function in excel to round the results to 2 decimals places. What you are importing is the absolute results of the formula, not what is displayed in excel, i.e. the format in excel has been set to displaying only 2 decimal positions vs the actual results of the calculation

----- Alice wrote: ----

I am using Office XP - I have a simple spreadsheet in Excel - I merge the data into a table in Word, but SOME the numbers on the original Excel document come out as a different decimal setting once merged into Word. I have tried all the obvious formatting options in Excel and Word and cannot get the decimal places to match. For exaple: $.08 in Excel merges into Word as $.0829 (the field that has the $.08 has a formula result - the formula takes another number and divides it by 7 - the wrong decimals all occur on these formula cells). This has happened on more than one occasion to me and a co-worker and neither one of us can figure it out! Please help!

 

[aLICE]

THANK YOU, CHARLIE! It worked. I never thought of the formula format - I tried everything else under format cells, columns and such.

 

[Suzanne S. Barnhill]

You can also do it with a simple numeric picture switch, just specifying
only two decimal places; Word will round it properly (not just truncate).

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

THANK YOU, CHARLIE! It worked. I never thought of the formula format - I

tried everything else under format cells, columns and such.

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm to foillow Suzanne's
suggestion

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>