data formatting
 

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?

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?

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.

"Frank Kabel" wrote in message
...
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?