Nov 21 2021 03:21 AM
I imported to tables from a pdf file. Then I wanted to change the cell type because it was not number format. Actually, I could not find out what was the format, but I can not do calculation with the cell content.
Nov 21 2021 03:45 AM
@Harmaskotes How exactly did you import?
Nov 21 2021 04:07 AM
Make sure that the Number Format is not set to Text.
Select values in a single column.
On the Data tab of the ribbon, select Text to Columns, then click Finish.
Does that solve the problem?
Nov 21 2021 10:31 AM
Nov 21 2021 10:32 AM