|
Re: Problems with Dates in excel when copy and pasting
JohnnieC wrote:
> does anyone know of a way to not make cells convert numbers to dates
> when copy and pasting? for example, if I copy and past scores from a
> baseball or soccer game was 1-2, excel automatically converts it to
> "2-Jan"
> I'd like to to just leave it as 1-2 when I paste it like that. anyone
> know how?
Hi JohnnieC
Format your cells to Text or input your score as '1-2 (note the
apostrophe preceding the 1).
On the other hand, if you're using Excel to keep scores, you may want
to do some calculations on those scores so why not enter in columns
A =A6 B =A6 C =A6 D:
TeamA =A6 1 =A6 2 =A6 TeamB
That way you'll keep the numbers as numbers and not have to worry about
date conversions.
Regards
Steve
|