excel dates

New Contributor

IF I HAVE A DATE IN COLUMN AI, SAY 1/1/22 AND I DRAG & DROP IT TO A2, IT CHANGES TO 2/1/22.

IS THERE AN OPTION I CAN CHOOSE SO IT JUST REPEATS 1/1/22? THANKS FOR ANY HELP, DAVID ROPER

2 Replies

@daviddavidr1000 

Select A1 and copy it (Ctrl+C).

Select for example A1:A10 and paste (Ctrl+V).

 

(Please turn off Caps Lock.)

Thanks for the reply. I tend to use capitals because I am a slow typist!