Excel auto format changing 1-1 into date

Originally Posted by oldchippy

Ok, with everything in column A, then go to Data > Text to columns and follow the steps through

This is just an example of data I copied from the net:

15 Sep, 2007 Portsmouth Barclays Premier League A 12:45 Y N Y 0-0
18 Sep, 2007 FC Porto Champions League Group Phase A 19:45 Y N Y 1-1
22 Sep, 2007 Birmingham City Barclays Premier League H 15:00 Y N Y 0-0
25 Sep, 2007 Reading Third round Carling Cup A 19:45 Y N Y 4-2
29 Sep, 2007 Wigan Athletic Barclays Premier League A 15:00 Y N Y 1-0
03 Oct, 2007 Olympique Marseille Champions League Group Phase H 19:45 Y N Y 0-1
07 Oct, 2007 Tottenham Hotspur Barclays Premier League H 15:00 Y N Y 2-2

Everything is as described above in column A. As far as I know, there isn’t any way to place the date the right way if it looks like it does after inserting it like you said in your first post.

It’s on the right cells if I paste it directly from the homepage, but the date thing is there.

There HAS to be a way to disable the date auto format thing

Anyways thanks for helping oldchippy.

Originally Posted by oldchippy

Which website?

This one for example:
http://www.liverpoolfc.tv/match/season/

You might need to get thru the splash screen and click the [Matches] menu.

Is it really impossible to turn off this function.
It can’t be right. There has to be something I can do to prevent Excel from turning 1-1 into 01-jan when I’m copy/pasting date into Excel.

I get this:

07-jul-07 Wrexham Friendly A 15:00 Y Y Y 03-feb
14-jul-07 Crewe Alexandra Friendly A 15:00 Y Y Y 3-0
17-jul-07 Werder Bremen Friendly A 19:15 Y N Y 03-feb
20-jul-07 Auxerre Friendly A 14:00 Y N Y 2-0
24-jul-07 South China FC Barclays Asia Trophy A 13:30 Y N Y 03-jan
27-jul-07 Portsmouth Barclays Asia Trophy A 13:30 Y N Y 02-apr
03-aug-07 Shanghai Shenhua Port of Rotterdam Tournament A 17:30 Y N Y 2-0
05-aug-07 Feyenoord Port of Rotterdam Tournament A 19:00 Y N Y 01-jan
11-aug-07 Aston Villa Barclays Premier League A 17:15 Y N Y 02-jan
15-aug-07 West Ham United Barclays Premier League Postponed 17:15 Y N Y P-P
15-aug-07 Toulouse Champions League Qualifier (1) A 15:30 Y N Y 1-0
19-aug-07 Chelsea Barclays Premier League H 16:00 Y N Y 01-jan
25-aug-07 Sunderland Barclays Premier League A 12:45 Y N Y 2-0
28-aug-07 Toulouse Champions League Qualifier (2) H 20:05 Y N Y 4-0
01-sep-07 Derby County Barclays Premier League H 15:00 Y N Y 6-0
15-sep-07 Portsmouth Barclays Premier League A 12:45 Y N Y 0-0
18-sep-07 FC Porto Champions League Group Phase A 19:45 Y N Y 01-jan
22-sep-07 Birmingham City Barclays Premier League H 15:00 Y N Y 0-0
25-sep-07 Reading Third round Carling Cup A 19:45 Y N Y 04-feb
29-sep-07 Wigan Athletic Barclays Premier League A 15:00 Y N Y 1-0
03 Oct, 2007 Olympique Marseille Champions League Group Phase H 19:45 Y N Y 0-1
07 Oct, 2007 Tottenham Hotspur Barclays Premier League H 15:00 Y N Y 02-feb
20 Oct, 2007 Everton Barclays Premier League A 12:45 Y N Y -
.
.
.

The problems continue down the last column for me.