Excel auto format changing 1-1 into date

**oldchippy** · 10-10-2007, 09:46 AM

Originally Posted by Laktose_65

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.

Which website?

**Laktose_65** · 10-10-2007, 09:56 AM

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.

**Laktose_65** · 10-12-2007, 07:53 AM

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.

**oldchippy** · 10-12-2007, 08:01 AM

I was getting the same problem, but not for the whole page, the first ten rows or so were formatting to dates, then the remained were formatting correctly, so may be its something to do with the web page data format????

**Laktose_65** · 10-12-2007, 09:40 AM

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.

**Mark@Work** · 10-12-2007, 11:28 AM

Select an area at least as big as the number of rows & columns required to paste into.

Right click : Format Cells... : Text

Then paste.

If the area is too big EXCEL will warn you, but if you tell it to carry on regardless it will work properly.

Mark.

**oldchippy** · 10-12-2007, 05:23 PM

Hi Mark,

Tried that, its getting the same problem. Row 12 prints as text OK, and also from row25 onwards. All the other cells retain hyperlinks - see attached

Also hyperlink score changes to date?