Number formatting not as required (sum issue) when exporting to Excel

Question

Hi Everybody, I am new here.

I would appreciate if someone would help with the issue as above.

I am not able to see the sum of the numbers that are being selected & I am not sure how to fix this. I hope someone can help here.

Kind regards,

Elaine

HowdoIQuestionMark · Accepted Answer

Thank you very much for your advice. I figured out a way to get excel to see the text as numbers by using the text to column function (Data Ribbon - Data Tools).

Karl Heinz Kremer · Answer

In general, the output you get when exporting to Word or Excel is what it is. There is not much you can do to control how the export is performed. We don't know enough about your problem to determine if there is something you can do. All the settings you have access to are in Acrobat's preferences: Open Preferences and select "Convert from PDF" and then select "Excel Workbook". The dialog that pops up has a couple of options for "Numeric Settings", and you can potentially specify what your numbers look like (as long as the problem is the decimal and thousands separators). If you cannot tweak your output this way, then unfortunately you are out of luck.

One option would be to write and run an Excel macro that will analyze the data in the cells and potentially apply a fix within Excel.

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