month & year format in two digits

  • Thread starter Thread starter Morphyus C via OfficeKB.com
  • Start date Start date
M

Morphyus C via OfficeKB.com

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month/Year Field Help 4
Change from mm/dd/yy to yy/mm> 3
Change Default Auto-Fill-In month 4
Date format - India/USA 7
Convert date to text without changing format dd/mm/yy 3
Entering date as MM/DD/YY no longer works, why? 1
Weird date format problem 2
MM/YY Formatting date Entry AND Display 2

Back
Top