I'm trying to reformat a cell with value 20100329163030, which is a date. I select the cell & record the following as a macro: F2, Home, right 4, /, right 2, /, move right 2, space, right 2, :, right 2, :, Enter.
So I end up with a field looking like: 2010/03/29 16:30:30. That's exactly what I want, but I want the macro to reformat any date. However, the macro records the value along with the format change.
So if I have a column with 10 unique dates, I would like the macro to reformat each cell without changing the date. Anyone know how to do this?
So I end up with a field looking like: 2010/03/29 16:30:30. That's exactly what I want, but I want the macro to reformat any date. However, the macro records the value along with the format change.
So if I have a column with 10 unique dates, I would like the macro to reformat each cell without changing the date. Anyone know how to do this?