Date Format
If your dates are real Excel dates (numbers formatted as dates) and not text
strings, VBA can help:
If ActiveCell.NumberFormat = "dd-mm-yy" Then _
ActiveCell.NumberFormat = "mm-dd-yy"
Apply it to the required range!
Regards,
Stefi
€˛Christopher Naveen€¯ ezt Ć*rta:
Hi,
I have extracted a data from a tool as xls, which contains dates with time
stamp but the dates are mixed in DD-MM-YY as well as MM-DD-YY in the same col.
How can i coenvert all the dates in that particular col to DD-MM-YY or
MM-DD-YY format. Can any one help me on this?
-CNS
|