First of all I use Office 2003.

When I copy/paste some data into Excel it turns everything that CAN be turned into a date into something like 01-jan when it should say 1-1.

1-1
4-5
8-3
18-12
Turns into:
01-jan
04-may
08-mar
18-dec

I can’t pre format the cells to be text. It’s still turns it into the date.

Isn’t there a function I can turn off so it doesn’t turn my data into dates?