Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Rounding merged figures
You need to apply a formattind switch in Word (which now ignores formatting
from the data file) Thus {Mergefield fieldname \# ",0.00"} see 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 Joe wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table of figures | Formatting Long Documents | |||
Table of figures | Tables | |||
Creating a Table of Figures | Microsoft Word Help | |||
View Merged Data Button not Working | Mailmerge | |||
How do I auto number figures in a merged document? | Page Layout |