Commas in Number in Text Boxes

Question

Hi, I am using PDF Mail Merge software to populate Adobe PDF forms from an excel sheet. I have an issue with a display in the text box: when I choose format "number separated by commas", no commas are displayed. However, when I type the number in the cell, it shows commas. Can anyone explain what I need to do that the text box would display commas when I import the numbers from an excel sheet? FYI, I tested different types of cell formatting in excel but it seems not to have any impact on the pdf text box.

George_Johnson · Answer

The field formatting that you set up in Acrobat will only work if Acrobat/Reader is used to populate the fields with data. If some other software is used, it probably won't work. What would work is to change the data from numbers to strings so that the commas are included.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded