Quote Originally Posted by FDibbins View Post
No, not necessarily. Formatting changes teh cosmetic appearance of a cell, it does not (generally) change teh contents of a cell

To edit an entire range of cells, highlight the range, scroll back to the top and click on the small yellow triangle you see on the left of the top cell. Select "Convert Text To Dates".
Thanks, but I don't see the triangle.
Here is my situation, I have an existing table with correctly formatted dates in a column, to make sure I select the column and apply Date as format in / / format.
Overtime, new dates are added, sometimes I paste them and when I paste them I can paste plain so they take the existing format but sometimes they don't they just remain in original date format until I select the whole column and apply Date format and then again go to Cell, edit and hit enter.


Sent from Z30 on Tapatalk