Collate Compulsory Field Format For Free

Q: How do you round off numbers in mail merge?

If you want to round to two decimal places, use \#0.00 in your merge field. If you want the number to have a dollar sign before it (for anything that is money), use \#$# in your merge field. If you want commas in your number, use \##, ### in your merge field.

Upload your document

Select documents

Up to 100 MB for PDF and up to 25 MB for DOC, DOCX, RTF, PPT, PPTX, JPEG, PNG, or TXT

Note: Integration described on this webpage may temporarily not be available.

0

Forms filled

0

Forms signed

0

Forms sent

Upload your document to the PDF editor

Type anywhere or sign your form

Print, email, fax, or export

Try it right now! Edit pdf

Users trust to manage documents on pdfFiller platform

65.5K+

documents added daily

53%

of documents created

from templates

4M

PDFs edited per month

238K

documents shared

per month

All-in-one PDF software

A single pill for all your PDF headaches. Edit, fill out, eSign, and share – on any device.

Start free trial

Collate Compulsory Field Format: edit PDF documents from anywhere

Document editing is a routine procedure for all those familiar to business paperwork. It is easy to edit a Word or PDF file, thanks to various tools that allow applying changes to documents. Since downloadable apps take up space while reducing its performance drastically. Online PDF editing tools are much more convenient for most people, however the vast part don't provide all the important features.

Now you have the option of avoiding all of these issues by working with templates online.

pdfFiller is a multi-purpose solution that allows to store, create, modify, sign and send your documents in just one browser tab. This platform supports primary file formats, such as PDF, Word, PowerPoint, images and Text. Using pdfFiller's document creation platform, make a fillable document from scratch, or upload an existing one to edit. pdfFiller works across all devices with active web connection.

pdfFiller provides you with an all-in-one online text editor, which simplifies the process online for all users. It features a range of tools to customize your template's layout and make it look professional. Using pdfFiller, you can edit pages on the go, set fillable fields anywhere on forms, add images, text formatting and digital signatures.

Create a document on your own or upload a form using the following methods:

01

Drag and drop a document from your device.

02

Get the form you need in the online library using the search field.

03

Open the Enter URL tab and insert the link to your sample.

04

Upload a document from cloud storage (Google Drive, Box, Dropbox, One Drive and others).

05

Browse the Legal library.

When uploaded, all your documents are available from the Docs folder. pdfFiller export your data to remote server, to provide you with extra level of security. Your information is accessible across all your devices instantly, and you're in control of who will read or work with your templates. Manage all your paperwork online in one browser tab and save your time.

How to Collate Compulsory Field Format

Related features

What our customers say about pdfFiller

See for yourself by reading reviews on the most popular resources:

Les S

2015-02-03

The service is great and the price for fax service is much less expensive than other companies. I love the fact I can fill out documents then email, fax, or file them away.

5

Wendy A.

2017-10-10

Very Easy to use and meet the needs that I had for documents able to make changes on a PDF and electronic sign them as well. Thank you for that ease of use. Ease of use I have a lot of documents in PDF format and they need to be completed by myself before sending for signatures and this helps me make that possible. Printing completed documents, I have to save them first and then find the ones that I have just amended to print

5

Get a powerful PDF editor for your Mac or Windows PC

Install the desktop app to quickly edit PDFs, create fillable forms, and securely store your documents in the cloud.

Download pdfFiller for Mac OS

Download pdfFiller for Windows PC

Edit and manage PDFs from anywhere using your iOS or Android device

Install our mobile app and edit PDFs using an award-winning toolkit wherever you go.

Download from App Store

Download from Google Play

Get a PDF editor in your Google Chrome browser

Install the pdfFiller extension for Google Chrome to fill out and edit PDFs straight from search results.

Download from Chrome Web Store

pdfFiller scores top ratings in multiple categories on G2

For pdfFiller’s FAQs

Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.

How do I change the format of numbers in a mail merge?

Perform the first different steps of the Mail Merge as usual (Start Mail Merge, Select Recipients and insert Merge Field) Select the number field you wish to change and press Shift+F9. The code of your Merge field is now shown.

How do I keep the same format in a mail merge?

In Excel, select the column that contains the ZIP Code/Postal Code field. On the Format menu, click Cells. Click the Number tab. Under Category, click Text, and then click OK. Save the data source. Then, continue with the mail merge operation in Word.

How do I format a mail merge in Word?

Select the field, such as Amount, as shown in this example. Press [Alt] + F9 to reveal the field coding. Edit the field by simply inserting a numeric switch code to the end of the field. Press [Alt] + F9 again.

How do I keep decimal places in mail merge?

In order to retain the two decimal places during mail merge, follow the instructions below: Press alt+f9 > Insert the field code \\# “0.00” after the title of the merge field that needs to be limited to two digits after the decimal point.

How do you round off numbers in mail merge?

If you want to round to two decimal places, use \\#0.00 in your merge field. If you want the number to have a dollar sign before it (for anything that is money), use \\#$# in your merge field. If you want commas in your number, use \\##, ### in your merge field.

How do I format numbers in a mail merge?

In the template document, while the merge field is selected, do the following to display the field code: Press Shift + F9 on Windows. Press FN + Shift + F9 on Mac. Remove \\* REFORMAT from the field code. Enter the switch in the field code. For example: Update the field: Press F9 on Windows.

How do you round off numbers in Word?

Round a number down by using the COUNTDOWN function. It works just the same as ROUND, except that it always rounds a number down. For example, if you want to round down 3.14159 to three decimal places: =COUNTDOWN(3.14159,3) which equals 3.141.

How do I keep the percentage format in a mail merge?

You can change the decimal fraction (e.g. 0.738) to a percentage (73.8) in Word. To do it embed the SEDGEFIELD inside another Word field. This lets you multiply the number coming from Excel by 100 before formatting. Remember to press Ctrl + F9 to make the field not the curly brackets on the keyboard.

eSignature workflows made easy

Sign, send for signature, and track documents in real-time with signNow.

Start free trial