| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Format number with either 0 or 1 decimal place
Hi
I am trying to do a mail merge where I have no access to edit the original data. I have a field that currently sits to 2 decimal places but I want the figure to pull through with either no decimal place or 1 if it is not a whole number. I have tried using #.# which works for those with a decimal place, but my whole numbers are always showing a '.' after which is not quite right. Can anyone advise the correct formatting to use? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| word mail merge does not format number imported to 2 decimal place | Mailmerge | |||
| number of decimal characters | Microsoft Word Help | |||
| Limit merge to 2 decimal place | Mailmerge | |||
| How to place a page number on a landscape page in portrait format | Page Layout | |||
| merge field numbering/decimal place problem | Mailmerge | |||
Hybrid Mode
