Seems simple enough - I want a cell to contain the value 5-0. I've tried
pre-formatting the cell to text before copying, I've tried formatting after
pasting - nothing works. As soon as I enter 5-0 Excel converts it to a date.
There is no "paste special" feature that works.

If this were one cell it might be simple enough, but I want to copy a large
table of which this is just one column of several with many rows.

Any ideas?
Thanks,
Steve