Forum Discussion
excel dates
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
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!
