A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Format number with either 0 or 1 decimal place

Thread Tools Display Modes
Old October 9th 17, 11:37 AM
FiFo FiFo is offline
Junior Member
First recorded activity by WordBanter: Oct 2017
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
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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 26th 08 11:34 PM
Limit merge to 2 decimal place Francis Mailmerge 3 February 12th 08 07: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 01:14 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.