Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.