Prevent auto date format

[crapit]

When I paste to excel, number with hyphen '-' i.e 2-5 , automatically become
02-may. I know that format cell as text before pasting can prevent
auto-date but I had a number of rows of data to paste.

 

[Dave Peterson]

When I have to do this for one value, I'll format the cell as Text and then
paste into the formula bar.

If I have lots, I'll paste into Notepad.
Then I'll save that file as a text file (*.txt)
Then use File|open to open that text file.
The text to columns wizard will appear and I'll be able to specify that these
fields should be treated as text.

Then I can copy|paste to its real location.

and close the *.txt file and then delete it using windows explorer.

 

[crapit]

No other method that involve excel itself?

When I have to do this for one value, I'll format the cell as Text and
then
paste into the formula bar.

If I have lots, I'll paste into Notepad.
Then I'll save that file as a text file (*.txt)
Then use File|open to open that text file.
The text to columns wizard will appear and I'll be able to specify that
these
fields should be treated as text.

Then I can copy|paste to its real location.

and close the *.txt file and then delete it using windows explorer.

 

[crapit]

I have a better way. paste data into microsoft word, format column into
text then paste special as text