month & year format in two digits
 

Hi folks....
is this possible in excel that if I just type MM/YY without this "/" and it
appears as MM/YY. For example if I type 0805 in the cell it should appears as
08/05 once entered.
Help will be appreciated.
Thanks
Morphyus


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Morphyus C via OfficeKB.com" wrote in message
...
Hi folks....
is this possible in excel that if I just type MM/YY without this "/" and
it
appears as MM/YY. For example if I type 0805 in the cell it should appears
as
08/05 once entered.
Help will be appreciated.
Thanks
Morphyus


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1