Excel dates

QuestionEdit

im filling out a spreadsheet where i have to put a lot of different dates in, is there any way that i can set the cell up with / between dates so i dont need to manually put them in each time? so if entering 02/05/2010 i would just need to type 02052010!  === Answer ===

see

http://www.google.co.uk/#hl=en&expIds=17259,17291,25901,26441,26446,26459,26518&xhr=t&q=excel+enter+date+without+slashes&cp=18&pf=p&sclient=psy&aq=f&aqi=g4g-o1&aql=&oq=excel+enter+date+w&gs_rfai=&pbx=1&fp=a5a33dd5101bdb24

for a number of suggestions