Link to home
Start Free TrialLog in
Avatar of IT Guy
IT GuyFlag for United States of America

asked on

Steps in Excel to copy exact same date value down column

I often need to copy the same date value (for example 4/14/2022) down an Excel column so that all values in subsequent rows have the same date value of 4/14/2022).


However, by default when copying the date value down a column the date value changes to reflect the date from the next day and doesn't retain the same date value that I want to copy down the column.


What process can I follow to copy the same date value down an Excel column?

ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
EXPERT CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial