After working with an imported file, I noticed that the numbers are being treated as text.
The numbers in some of the columns are preceded by a single quote (" ’ "). These columns can be readily converted to numbers using Data–Text to Columns.
Single quotes do not precede the numbers in other columns and I am at a loss as to how to format those columns as numbers.
I would appreciate any help.