Football scores in Excel

[ZexyZahid]

I am trying to figure out how to include football scores in Microsoft Excel.

For example I want to write down in one cell '2-4'. But instead it changes it automatically into 2 april. And if I write down '2-1' it changes automatically into 2 january.

I've tried to search in the options, but I didn't find it so far.

One solution is that I write only one figure in one cell, but I don't want to do that, because I want to simply copy results into a Excel file.

 

[Manly]

You selected all cells, right click, format cells, General formatting? Rather than 'date'.

 

[Chewie]

Nah it automatically changes for things like that. I've had that problem too

 

[ZexyZahid]

Yeah, I've already tried to change the cell properties.

 

[Manly]

I'm out then.

Shot in the dark as it was.

 

[Chewie]

Change the formatting to 'text'. It works

Chewie added 0 Minutes and 20 Seconds later...

Just figured it out then. Been bugging me too

 

[ZexyZahid]

That seems to work. But the big problem is that if you copy from a website the football scores in the worksheet Excel changes it again to dates. After changing the cell properties, the figures will be changed in a different number and you've got to manually alter all the football scores. If you copy a lot, that will cost a lot of time to do it.

 

[Chewie]

Could you format all the cells and then copy and paste?

 

[ZexyZahid]

I've found it!

Just do everything what here is written: MS Excel: Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97

Except instead of that code, include this code.

Sub formatscores()
'
' formatscores Macro
'

'
Columns("C:C").Select
Selection.NumberFormat = "d-m"
Range("I3").Select
End Sub

I don't know if the above code has been quoted correctly. If it doesn't help, just check out where I got the information: Excel Help Forum - View Single Post - Stop Excel from converting football scores into dates

 

[Abhas]

If all your scores are in a single column, just select the entire column, press CTRL + 1 (Format cells), and in the Number tab, select text. It should make the entire column text formatted, and it should automatically change the dates to the actual text.

Abhas added 3 Minutes and 27 Seconds later...

Or, if that doesn't work, try Paste Special..
Select "values" and click ok.

 

[ZexyZahid]

It doesn't work. The solution I provided above your post is the best one.

 

[SciD]

Copy to notepad and then to excel.

 

[ZexyZahid]

I did that already before I created the thread.

But like I said: I already got the solution.

 

[sohum]

If you type it in the form '2-1 then it won't change it into a date.

 

[Abhas]

But he's pasting it.. don't know why Paste special's not working though..