 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2003merging word and excel, format question
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 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 :-) 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 :-) 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. > ----- Cindy M -WordMVP- wrote: ----- > [quoted text clipped - 15 lines] > This reply is posted in the Newsgroup; please post any follow question or reply > in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.