vzachin
01-20-2012, 05:29 AM
hi
this is a non-VBA question. I'm using Excel 2003; when i input a date into a cell, e.g. 1/21, the cell automatically changes to 21-Jan after i tab into another cell.
when i look at Format-->Cells--> it shows Custom-->d-mmmm.
is there a way to change the default to show mm/dd/yy?
i don't want to format the cells everytime i open a new sheet or workbook.
thanks
zach
this is a non-VBA question. I'm using Excel 2003; when i input a date into a cell, e.g. 1/21, the cell automatically changes to 21-Jan after i tab into another cell.
when i look at Format-->Cells--> it shows Custom-->d-mmmm.
is there a way to change the default to show mm/dd/yy?
i don't want to format the cells everytime i open a new sheet or workbook.
thanks
zach