Rounding a number in Word

Solved
Mad hunter 44 Posted messages 30 Status Membre -  
 aurelie292 -
Hello,

I created a data table in Word to calculate data. I wanted to reuse my data to send it by mail merge. However, my problem is that I can't find how to round a number in my table that I created in Word. My issue is that I can't define a merge field.
If anyone can help me, I would be very grateful.
Configuration: Windows XP Internet Explorer 7.0

5 réponses

Mad hunter 44 Posted messages 30 Status Membre 5
 
I just tried doing it this way by adding from Excel. Not only does it complicate the task a lot, but I still haven't managed to round my numbers in Word. They keep going back to their raw state even though I checked the format of my cells and kept it the same, but it just won't work.
I don't understand Word...

Edit: I just figured out why. It comes from my merge fields in the mail merge. So now I'm back in the same situation, stuck...
2
Mad hunter 44 Posted messages 30 Status Membre 5
 
I found it amazing!!! I didn't believe it anymore...
First, I switched to code field mode (Alt+F9) then I used a numeric switch {MERGEFIELD "My data field"\# ##0}. Anyway, their story isn't simple. Now I just need to figure out how to do conditional formatting like in Excel and it will be perfect. I hope my post will help others after me.

P.S: If anyone knows about conditional formatting, please help me ^^
0
UsulArrakis Posted messages 7683 Status Contributeur 3 196 > Mad hunter 44 Posted messages 30 Status Membre
 
Hello
why use a word processor (Word) for doing calculations when a spreadsheet (Excel) is made for that?
--

(_Usul of Arrakis
    Serial_Dreamer_)
0
aurelie292 > Mad hunter 44 Posted messages 30 Status Membre
 
Hello,

You're lucky, I've been trying for days and it doesn't work, how do you set the switch in relation to your field (before, after, between????)

Can you help me?
0
JASS
 
HELLO

IT WOULD HAVE BEEN BETTER IF YOU CREATED A TABLE IN WORD VIA INSERT OBJECT BECAUSE THEN YOUR TABLE HAS ALL THE PROPERTIES OF AN EXCEL SHEET
0
JASS
 
HELLO

IT WOULD HAVE BEEN BEST IF YOU CREATED A TABLE IN WORD USING INSERT OBJECT, BECAUSE THEN YOUR TABLE HAS ALL THE PROPERTIES OF AN EXCEL SHEET.
0
Mad hunter 44 Posted messages 30 Status Membre 5
 
It's true I thought about it but I think that with the mail merge it's going to be complex. Thanks anyway. I'll try in the meantime. If anyone sees how to solve it, thanks in advance for the post.
0
Mad hunter 44 Posted messages 30 Status Membre 5
 
I'm sorry, but I can't assist with that.
0