Inicio
Índice de funcionalidades

Adapt Requisite Field Format

Q: How do you format currency in mail merge?

To format a numeric merge field, use the \# switches. For example, to display a currency field as “$125.23”, the merge field should be defined as {SEDGEFIELD object. Mayfield \# $#, ##0.00}. To format a date merge field, use the \@ switches.

Q: How do you do a dollar amount in a 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.

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

Adapt Requisite Field Format: edit PDF documents from anywhere

The PDF is a common file format used in business, thanks to the availability. You can open them on from any device, and they'll be readable similarly. You can open it on any computer or phone running any OS — it'll appear exactly the same.

Data safety is another reason we rather use PDF files to store and share confidential information and documents. That’s why it’s essential to pick a secure editor for working online. Using an online solution, it is possible to track a viewing history to find out who had access to the file before.

pdfFiller is an online editor that allows you to create, edit, sign, and send your PDF using just one browser tab. Convert MS Word file or a Google Sheet, start editing it and create fillable fields to make a document singable. Use the completed document for personal needs or share it with others in any convenient way — you'll get notified when a person opens and completes the form.

Use editing tools to type in text, annotate and highlight. Add fillable fields and send to sign. Change a template’s page order. Add and edit visual content. Ask other users to fill out the fields and request an attachment. Once a document is completed, download it to your device or save it to the third-party integration cloud.

Complete any document with pdfFiller in four steps:

01

Browse for your document through the pdfFiller's uploader.

02

Proceed to editing features by clicking the Tools tab. Now you can change the document's content.

03

Add input fields if you need any; pdfFiller supports text, checkboxes, radio buttons, dropdown lists etc.

04

When you finish editing, click the 'Done' button and email, print or save your document.

How to Adapt Requisite Field Format

Related features

What our customers say about pdfFiller

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

Dr R

2015-12-27

I was shocked to learn AFTER I PAID that the "monthly" payment touted in 3 big choice boxes was ONLY and effective cost IF I paid an annual fee IN FULL. THAT WAS NOT CLEAR and I feel duped. However, I am extremely pleased with what you offer AND the ease of using your site. It is well worth the 29.99/month vs what I thought was 9.99. You really need to make that clear for your customers, though. Don't start a customer relationship with the customer feeling duped or tricked.

5

Bill J H

2016-10-19

Too many going back and forth tasks to complete a form. You need to make this more friendly for the user not experienced. Make it like MS Word with what is available from the subscription, as for example: when I needed to use the eraser, it brought me to a screen to purchase to get, even though I have a monthly subscription. Not fair.

4

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

List of extra features

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 you format currency in mail merge?

To format a numeric merge field, use the \\# switches. For example, to display a currency field as “$125.23”, the merge field should be defined as {SEDGEFIELD object. Mayfield \\# $#, ##0.00}. To format a date merge field, use the \\@ switches.

How do I change the number format 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 number format in a mail merge?

To apply number formatting to an Excel mail merge field: Press [Alt] + F9 to reveal the field coding. Or, right-click on the mail merge field and choose the Toggle Field Code option. You should now see the actual field code for the field which should look something like {SEDGEFIELD Amount}.

How do you do a dollar amount in a 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 you keep a number 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.

eSignature workflows made easy

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

Start free trial