That works with typing but not with pasting. You can easily try it yourself. Open a blank worksheet, format one column as General and one column as Text. Type "Feb 79" in a cell in both columns. They are displayed differently. Then type "Feb 79" somewhere else and put it on the clipboard. Paste into both columns. Both columns will show identical date data.

Any other ideas?