| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Round number down in mail merge
I have a number being merged from excel which is formatted to 1 decimal
place in excel (e.g. 1.6). When it comes through to word as part of the mail merge it displays as a true number (1.666666666666667) and I want it to display to 1dp. I'm aware of switches to control formatting but don't know how to do this with number formats / decimal places within the word doc. Can anyone shed light on it? -- Regards Andy Andy Roberts Win XP, Office 2007 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round numbers to 2 decimal places when using Word Mail Merge | Mailmerge | |||
| Round Down Merge field | Mailmerge | |||
| How can you round a number in a non-calculating field? | Microsoft Word Help | |||
| Moving addresses round on mail merge labels? | Mailmerge | |||
| sort mail merge by merge record number | Mailmerge | |||
Threaded Mode