Merge Number Format For Free
Drop document here to upload
Up to 100 MB for PDF and up to 25 MB for DOC, DOCX, RTF, PPT, PPTX, JPEG, PNG, JFIF, XLS, XLSX or TXT
Note: Integration described on this webpage may temporarily not be available.
0
Forms filled
0
Forms signed
0
Forms sent
Discover the simplicity of processing PDFs online
Upload your document in seconds
Fill out, edit, or eSign your PDF hassle-free
Download, export, or share your edited file instantly
Top-rated PDF software recognized for its ease of use, powerful features, and impeccable support
Every PDF tool you need to get documents done paper-free
Create & edit PDFs
Generate new PDFs from scratch or transform existing documents into reusable templates. Type anywhere on a PDF, rewrite original PDF content, insert images or graphics, redact sensitive details, and highlight important information using an intuitive online editor.
Fill out & sign PDF forms
Say goodbye to error-prone manual hassles. Complete any PDF document electronically – even while on the go. Pre-fill multiple PDFs simultaneously or extract responses from completed forms with ease.
Organize & convert PDFs
Add, remove, or rearrange pages inside your PDFs in seconds. Create new documents by merging or splitting PDFs. Instantly convert edited files to various formats when you download or export them.
Collect data and approvals
Transform static documents into interactive fillable forms by dragging and dropping various types of fillable fields on your PDFs. Publish these forms on websites or share them via a direct link to capture data, collect signatures, and request payments.
Export documents with ease
Share, email, print, fax, or download edited documents in just a few clicks. Quickly export and import documents from popular cloud storage services like Google Drive, Box, and Dropbox.
Store documents safely
Store an unlimited number of documents and templates securely in the cloud and access them from any location or device. Add an extra level of protection to documents by locking them with a password, placing them in encrypted folders, or requesting user authentication.
Customer trust by the numbers
64M+
users worldwide
4.6/5
average user rating
4M
PDFs edited per month
9 min
average to create and edit a PDF
Join 64+ million people using paperless workflows to drive productivity and cut costs
Why choose our PDF solution?
Cloud-native PDF editor
Access powerful PDF tools, as well as your documents and templates, from anywhere. No installation needed.
Top-rated for ease of use
Create, edit, and fill out PDF documents faster with an intuitive UI that only takes minutes to master.
Industry-leading customer service
Enjoy peace of mind with an award-winning customer support team always within reach.
What our customers say about pdfFiller
See for yourself by reading reviews on the most popular resources:
I completed the first PDF form and it was a little tough maneuvering through the documents, savings. It was a little disingenuous to wait until I was finished to document to find out that I would be billed annually as apposed to monthly, when the advertising gave the amount payable monthly.
2015-11-03
So far so good. Was very helpful in completing government report on non-fillable .pdf document. That was the original purchase purpose. Now trying out modification / repair of existing fillable forms.
2016-02-04
It fulfills my needs. I use it on my pad, but becasue of the problem of an empty folder I am trying out the internet version. Still good. I can use both.
2018-03-13
PDF FILLER is amazing and very easy to use. It makes doing business remotely and working with clients who have very busy schedules much simpler. I recommend PDF FILLER to all my co-workers and associations.
2018-11-07
Very user friendly!
It is easy to use. Instructions are clear and the forms are easy to fill out accurately. I only use it once a year - at tax time, but using this program to fill out tax forms is quick and easy.
I have not had any issues. I'm sure if a person uses it a lot there are bound to be some, but I use it once a year and it works fine for my uses.
2019-05-17
Took me a minute to get the hang of…
Took me a minute to get the hang of it... after that no problem. Not sure if there is a tutorial for typing in text and moving the text where you need it...
2021-08-14
I couldn't insert tables and extend the…
I couldn't insert tables and extend the size of the windows to write more notes. I didn't't find the explanation on how to do so
2021-04-15
Great Experience and Efficient PDF's
I only needed to use it for a few items I needed to update. The experience was easy and great. I enjoyed using it for what I needed in the moment. Once I cancelled my subscription they handled it promptly and professionally. If I am ever in need of PDF services again, I will definitely consider their services and so should you!!! THANKS PDF FILLER!
2021-01-05
Elisa stepped right into action and helped me with my accounting issue. It is so nice to be able to have an account services individual help a customer with ease. This is a very rare occasion especially during this pandemic. Thank you Elisa!!!!!
2020-08-14
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.
What if I have more questions?
Contact Support
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.
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 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 I format a mail merge field 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 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 keep source formatting in 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 you show 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.
#1 usability according to G2
Try the PDF solution that respects your time.