How can I defeat Excel's auto-reformating into date format?

S

stebro

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
 
S

stebro

Thank you Frank for your reply, however this doesn't work. The source for my
data is a website, and the "paste special" options I have are html, unicode
text, or text. "Values" is not available for this paste. And as I
mentioned, pre-formatting doesn't help; as soon as Excel sees the 5-0 it
changes the format to a date.


Thanks,
Steve
 
Top