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!

Excel-Changing calculated dates to "hard" dates
Working of hard disk with diagram - Guide
How to change author in excel - Guide
How to install a second hard drive windows 11 - Guide
Number to words in excel - Guide
How to change date format in excel - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

lava hard reset & factory reset

Similar discussions

Subscribe To Our Newsletter!