1) Format your target column ahead of time with the desired display format
2) When pasting into this column, use Paste Special > Values