Hello,

i am currently entering some cheque details by month.

First thing i need to enter is the date and i hate having to retype 24/11/2011 for every cheque. Can i set the Month & Year as a format please?

I mean can i input 24 and hit enter/tab and have 24/11/2011 in my cell?

I am using MS Excel 2010

Thanks a lot