try this
Replace the non numeric values to
Null
and then try to alter the type.
update purchaserequestdetail set quantity = case ISNUMERIC(quantity) when 1 then quantity else null end
ALTER TABLE purchaserequestdetail ALTER COLUMN quantity float
Note : Take a backup of the table before updating.