day/date/year all together

  • Thread starter Dumber than a pocket full of rocks
  • Start date
D

Dumber than a pocket full of rocks

can I enter a day into my date & year and then drag to auto fill if so how?
 
G

Gord Dibben

Not sure what you want, but how about formatting the date as Custom

dddd, mmmm yyyy


Gord Dibben MS Excel MVP
 
M

Marcelo

Hi,

enter the date 04/Jul/2006 for eg

click on the little black squre on the right down of the selected cell end
drag to auto fill

hth
regards from Brazil
Marcelo

"Dumber than a pocket full of rocks" escreveu:
 
Top