date formatting shortcut required

[bite_tony]

hi,
this is only a really small thing, but itd save me LOADS of time..
I have a spreadsheet where I have to put in a lot of dates, the column is date formatted but as far as I can see I still have to at least put the dashes in so 5/3/13 gets reformatted to 05/03/2013, which is fine. What i'd like to know is if there is a way I could just type in 5313, or even better just 53 and have the excel reformat that to 05/03/2013

I have clicked around and tried to find the answer.. but it is evading me, I have ti enter a lot of dates very quickly, so it'd be more helpful than it sounds.

cheers

 

[Andrew Poulsom]

You can use eg 5-3.

 

[VoG]

This may help Date And Time Entry

 

[bite_tony]

Hi, thanks to you both!! Andrew what I was looking for, but I am now going to investigate the code in the link VoG posted, I reckon I could learn somethin'!! thanks again