Forum Discussion
Changing cell type in the table imported from pdf
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.
4 Replies
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?
- Thanks. Finally what helped: Replacing (Ctrl H) , by space, and then I could change format to number.
- Thanks. Finally what helped: Replacing (Ctrl H) , by space, and then I could change format to number
Harmaskotes How exactly did you import?
