Hi
try pre-formating the cells as 'Text' and use Paste Special - Values

--
Regards
Frank Kabel
Frankfurt, Germany

"stebro" schrieb im Newsbeitrag
...
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