Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Joe
 
Posts: n/a
Default Rounding merged figures

Hi

i am trying to merge some formula results from excel into word. I have
rounded the formula result in excel to two decimal places (using the
=Round(**,2)) but when i merge the data accros to word it puts all the
decimal places back.
I then tried copying the resuls into another cell (using paste special) and
merging that field but i got the same result.

I am using word2003 to do this.

I have just tried the same thing on word2000 and i get the results i need,
but i need to get it working in word 2003 - has any body got any ideas

thanks
--
Cheers
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table of figures joemoran7 Formatting Long Documents 2 November 2nd 05 05:29 PM
Table of figures joemoran7 Tables 1 November 2nd 05 05:23 PM
Creating a Table of Figures Dee Microsoft Word Help 7 July 14th 05 12:15 AM
View Merged Data Button not Working AlanMagppie Mailmerge 2 June 10th 05 07:12 PM
How do I auto number figures in a merged document? Samantha Page Layout 1 May 17th 05 05:27 AM


All times are GMT +1. The time now is 02:00 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"