excel date ?

[ªÎ¿°¤H@work]

Dear All,

I don't know how to do a cell convertion as below:

Let say input 140709 into a cell and then press Enter or Tab Key. I want
the cell auto change to 14/07/09 after pressed Enter or Tab key.

Did anyone know how to do it automatically ?

Many thanks for help.

William Chan

 

[T. Valko]

See this:

http://www.cpearson.com/Excel/DateTimeEntry.htm