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?
Bookmarks