data formatting

[Choung Chao]

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?

 

[Frank Kabel]

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

 

[Choung Chao]

I tried that application and it doesn't work.

I also checked my regional settings and I tried them both and it still
doesn't work.