Changing cell type in the table imported from pdf

New Contributor

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

@Harmaskotes How exactly did you import?

@Harmaskotes 

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