Excel-Changing calculated dates to "hard" dates

Closed
Ritabook - Mar 1, 2015 at 09:40 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 3, 2015 at 11:09 AM
Hello,
I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change every time I add a new row.
Help greatly appreciated!


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 3, 2015 at 11:09 AM
Hi Ritabook,

Try this:
Select and copy column A, then use paste special on column A, pasting values only.

Best regards,
Trowa
0