Problem with number vs text format

Options

I have a column in which some numbers are recognized as such and can be sorted, while other entries are recognized as text. How can I have all recognized as numbers?


Answers