How to Insert Formulas in Excel After PDF Conversion? Then format cells in excel copied from a converted pdf file

Question

I converted a PDF file to Excel, but now I am unable to insert formulas in the Excel file

What do I do

Answer 1

Hello,

Without seeing the specifics, I can only give you the most common issue in this scenario -

When you converted from PDF, likely all values are text value and likely there's hidden format, so it can cause issue with using formulas.

Select the entire sheet, find the eraser icon and then choose Clear Formats, see if that helps.

If there's number value that still won't work, you want to check to see if the column is indeed defined as number value, as it can be text value.