Excel 2007 : Change of format

[Oyvind]

Football-results is mostly displayed like this: 1-2. But when I copy a list of results from a website (like Wikipedia) and paste them into Excel, some of them changes to a date...

I have tried to prepare Excel for what I'm going to paste, by marking the cells and change the format to "Text". It doesn't help. And it's no help changing it after pasting.

What should I do to get this right???!?

[ncmay]

Try the following website:

http://www.microsoft.com/technet/scr...8/hey0627.mspx

[Oyvind]

I have read it, and I'm told to run this script:

Const xlTextFormat = 2
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.OpenText "C:\Scripts\Test.txt",,,,,,,,True,,,, _
Array(Array(1, xlTextFormat), Array(2, xlTextFormat), Array(3, xlTextFormat))

Only one problem: I don't know how to run a script... I am not a programmer, just an regular user of Excel.
So please help me out here:-)