I always select the range of rows and I always check to treat (what looks
like) a number as a number.

Still doesn't work. Also, I'm not keen on setting up two helper columns
(Andy's suggestion) as it seems a waste when one will (at least used to) do
it.

Any other thoughts?