Thread Tools Display Modes
  #1   Report Post  
FiFo FiFo is offline
Junior Member
Posts: 1
Default Format number with either 0 or 1 decimal place


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?
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
word mail merge does not format number imported to 2 decimal place elginone Mailmerge 1 June 1st 10 10:27 PM
number of decimal characters RKurt Microsoft Word Help 1 November 27th 08 12:34 AM
Limit merge to 2 decimal place Francis Mailmerge 3 February 12th 08 08:17 AM
How to place a page number on a landscape page in portrait format Satyamurti Page Layout 1 April 5th 07 04:13 AM
merge field numbering/decimal place problem gremlinsgimi Mailmerge 1 April 9th 05 09:40 AM

All times are GMT +1. The time now is 11:23 PM.

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"