Hi
I need help with formatting PDF report in excel. I have system generated PDF reports, i have converted/exported those PDF reports in excel in order summarize the reports. In PDF table i have some negative numbers that do not add up when i sum up the table. i have used trim formula to make sure there is no space but still doesn't work.
Please see example above. Could someone please advise what should i do, how i can format these numbers so i can use formulas to sum up the table, rather deleting and then manually typing each negative number. Thank you
I need help with formatting PDF report in excel. I have system generated PDF reports, i have converted/exported those PDF reports in excel in order summarize the reports. In PDF table i have some negative numbers that do not add up when i sum up the table. i have used trim formula to make sure there is no space but still doesn't work.
Please see example above. Could someone please advise what should i do, how i can format these numbers so i can use formulas to sum up the table, rather deleting and then manually typing each negative number. Thank you