merging word and excel, format question

[Tom]

When I merge, I am loosing the format in some cells from excel, i.e. excel shows a value of "1.60" and word shows "1.584532356". Does anyone know how to round this back to display "1.60" in the merged document?
thanks

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VG9t?=,

When I merge, I am loosing the format in some cells from excel, i.e. excel

shows a value of "1.60" and word shows "1.584532356". Does anyone know how to
round this back to display "1.60" in the merged document?Unfortunately, you don't mention the version of Word, but I assume it's 2002 or
2003. You'll find information on what's happening, why it's happening, and what
your choices are on my website, in the Mail Merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Tom]

Yes, I'm using Word 2002. I checked your site and am confused as to where to put the field switch. I used the insert field command (in the word document). Word put the two sideways carots on each side of my field, i.e. [[Term_years]]. Where do I put the syntax of \# "0.00"? I think this is the correct way to round down the number. Thanks for that link to your site Cindy.


----- Cindy M -WordMVP- wrote: -----

Hi =?Utf-8?B?VG9t?=,

When I merge, I am loosing the format in some cells from excel, i.e. excel

shows a value of "1.60" and word shows "1.584532356". Does anyone know how to
round this back to display "1.60" in the merged document?Unfortunately, you don't mention the version of Word, but I assume it's 2002 or
2003. You'll find information on what's happening, why it's happening, and what
your choices are on my website, in the Mail Merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Peter Jamieson]

Use Alt-F9 to display the underlying field code. You will then see something
like

{ MERGEFIELD Term_years }

instead of something like

<<Term_years>>

Then type the \#"0.00" after Term_years, so you see something like

{ MERGEFIELD Term_years \#"0.00" }

then you can use Alt-F9 to toggle back to the view where you see

<<Term_years>>

--
Peter Jamieson
MS Word MVP

Yes, I'm using Word 2002. I checked your site and am confused as to where

to put the field switch. I used the insert field command (in the word
document). Word put the two sideways carots on each side of my field, i.e.
[[Term_years]]. Where do I put the syntax of \# "0.00"? I think this is
the correct way to round down the number. Thanks for that link to your site
Cindy.