reformat date entries with the help of a macro and the text formula
Posted on 2013-12-12
On the current workbook with many worksheets ...
... there are date entries in Column C and D in all of the worksheets.
They are formatted as pure text.
By means of a macro I would like to re-format these date entries in Column C and D with the following formula : Text(A2;"JJJJMMDD")
Could somebody please help me with that.
Thank you very much in advance. Regards, Andreas