Hi
this settings depends on your regional settings (difference between
mm/dd/yyyy or dd/mm/yyyy settings). You may also have a look at the
following addin:
http://www.xldynamic.com/source/xld.QDEDownload.html

--
Regards
Frank Kabel
Frankfurt, Germany

Choung Chao wrote:
I formatted my cell to a dd/mm/yy format. On my old computer, I used
to be able to enter dec 5 in a cell and it would automatically change
it to 05/12/04. Now on my new computer when I enter dec 5 in a cell
it gives me 01/12/05. How can I get it to enter the right day and
year in a cell without actually having to write the year in?