Trying to update a date format change to an entire column

[jojo777]

But I can't figure out how to update all the cells at once without having to hit enter on each cell. Is there a tick to do this? I have tried copying and pasting special - formats but that isn't committing the change unless I hit enter on every cell Thanks!

 

[Luke M]

My guess is that you have Dates/Numbers stored as text, you've formatted the cells to be Dates, but XL hasn't converted them all to numbers yet. To do this in one shot:


1. Type the number 1 into a cell

2. Copy that cell

3. Select the range of data you need to convert

4. Right-click, Paste special

5. Select Values Only, and multiply. Ok out.

6. Done!