[Igetp2s]

I am having a problem copying and pasting data to Excel. I am trying to copy won-lost records, and it is coming out as a date in Excel. For example 9-10 would come out Sep 10.

This is probably very basic but I'm having the hardest time fixing this. What do I need to do so that Excel keeps the data as is?

Thanks.

[rolemand]

Format the cell as text and then copy and paste special values into that cell.

[Breaker]

If you are going to paste both numbers in one cell, just insert a space or point in front, no formatting neccesary.
Let
9-10
become
.9-10

If you want to do calculations with the numbers spread them out over two cells.

[maritime]

Right click on letter at top of the column you are using and choose format cells. Then pick text.

However, doing it that way kind of defeats the purpose of using such a powerful mathematical program as excel.
Instead you should use 2 columns. 1 for wins and 1 for losses. Then you could enter the data as actual numbers in stead of text. This would allow you to then do calculations with the data. You won't be able to do calculations if you are entering wins-losses like you said.

[Igetp2s]

Let me be as specific as possible in what I am doing, because it's still not working.

Here is where I am getting my data from:

http://www.goldsheet.com/06cfblog.php


I am copying the Air Force data and pasting special as text to Excel. All the data gets put into column A. I am then trying to split it text to columns so that I can work with the data, but the Oct 21 12-19 score keeps coming up as Dec-19 no matter how I try formatting it beforehand. If I try to format it afterwrads some number comes up instead.

[MrX]

Well, in my version of Excel, during the text-to-columns process (step 3 of 3) Excel lets you set the data format of each column. If you set the columns to text, everything is fine.

[Igetp2s]

OK I think that might do the trick. I never realized you could change the formatting within the text to columns process. Thanks for the help, I learned something new.

[Breaker]

This will take some work, but you can do this using four programs:
Your browser
Notepad
MS Works
Excel

Click on reply to any tread on the SBR board
When you paste the data into the reply box of the SBR board and then click on "preview post"
S.09*,,Tenn,,,,,,,,,,,,,,W,,,,+20,,30-31,o47
becomes
S.09* Tenn W +20 30-31 o47

Copy all that data into Notepad.
Go down the list and erase any spaces you find in names you want in one cell, for example change
NEW MEX.
into
NEWMEX.

Click on CTRL+H or on Replace under Edit
In the top field (Replace what) just put one space, nothing else
In the bottom field (Replace with) put a comma
On the right, select Replace All

So
S.09* Tenn W +20 30-31 o47
becomes
S.09*,Tenn,W,+20,30-31,o47

Now do the same replacing every "-" with a "," (don't use the quotation marks), so

S.09*,Tenn,W,+20,30-31,o47
becomes
S.09*,Tenn,W,+20,30,31,o47

You can do a whole block of data at once, I'm just using one example.
Now copy all this and paste it into an Microsoft Works Spreadsheet.

You will see that every comma makes the data behind it go into a new cell, so
S.09*,Tenn,W,+20,30,31,o47
becomes
S.09* l Tenn l W l +20 l 30 l 31 l o47

Now you can paste all that into your excel sheet.

[MrX]

No need for all of that, the tables on that page are in a fixed width format.