Heads up to anyone encountering this, could also be a whitespace issue e.g if column is of type number but you by accident have " -50" instead of just "-50", ignore strings here - they're just to show whitespace case