Change of format
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???!?
Last edited by Oyvind; 09-18-2009 at 06:40 AM. Reason: Changed the heading to fit with the regulations
Try the following website:
http://www.microsoft.com/technet/scr...8/hey0627.mspx
Re: Change of format (PLEASE help me quick)
I have read it, and I'm told to run this script:
Only one problem: I don't know how to run a script... I am not a programmer, just an regular user of Excel.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))
So please help me out here:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks