|
Re: Problems with Dates in excel when copy and pasting
JohnnieC wrote:
> I must be doing something wrong. when I paste 2-1 for example it still
> shows 1-Feb, and then if I format it to text it shows 38749
>
> I couldn't find a paste value in the past special section. I found
> paste text, but got the same result as before.
>
> Here's am example of something I was trying to paste from MSNBC.COM
>
> Its the last 5 Yankees games
>
>
> July 16 vs. Chi White Sox W 6-4 53-36 W: Wright L: Garcia S: Rivera BOX
> SCORE
> July 17 vs. Seattle W 4-2 54-36 W: Wang L: Washburn S: Rivera BOX SCORE
>
> July 18 vs. Seattle W 5-4 55-36 W: Proctor L: Mateo BOX SCORE
> July 19 vs. Seattle L 3-2 55-37 W: Lowe L: Johnson S: Putz BOX SCORE
> July 20 at Toronto L 5-4 55-38
>
> and what came up after I formatted the scores to text was
>
> 16-Jul vs. Chi White Sox W 38872 53-36 W: Wright L: Garcia S:
> Rivera BOX SCORE
> 17-Jul vs. Seattle W 38809 54-36 W: Wang L: Washburn S: Rivera BOX
> SCORE
> 18-Jul vs. Seattle W 38841 55-36 W: Proctor L: Mateo BOX SCORE
> 19-Jul vs. Seattle L 38778 55-37 W: Lowe L: Johnson S: Putz BOX SCORE
> 20-Jul at Toronto L 38841 55-38
>
>
> --
Hi JohnnieC
If you're pasting and then changing the format, it's already too late
as you've pasted the score as a "date"
Format your cell to Text before pasting the data and you should be OK.
(I still contend though that you may be better off putting the scores
into separate cells otherwise you might just as well be using Word)
Regards
Steve
|