Dear All,
I have a column in this Excel defined as Date format, "dd-MMM-yy"
type.
However, when I open the file, some cells have value like
"20/11/2005".
After I double-clicked the cell, it would change to "20-Nov-05".
Anyone could advise what "double click" triggered in this case? How
to
change all the values in the column simultaneously?
Thanks.
--
qqxz
------------------------------------------------------------------------
qqxz's Profile:
http://www.excelforum.com/member.php...o&userid=30773
View this thread:
http://www.excelforum.com/showthread...hreadid=504421