Paste Special option to paste as Text or as a Number
It would be incredibly helpful to have, as a Paste Special option, the ability to paste as text or as a number. By this, I mean pasting as data type 1 or data type 2. This would save the user from having to manually convert data with the TEXT function or by multiplying by 1 (depending on the data type to which he is trying to convert his data). This would also allow the data to be converted in-place rather than using a helper column or Text to Columns.