can I enter a day into my date & year and then drag to auto fill if so how?
D Dumber than a pocket full of rocks Jul 4, 2006 #1 can I enter a day into my date & year and then drag to auto fill if so how?
G Gord Dibben Jul 4, 2006 #2 Not sure what you want, but how about formatting the date as Custom dddd, mmmm yyyy Gord Dibben MS Excel MVP
Not sure what you want, but how about formatting the date as Custom dddd, mmmm yyyy Gord Dibben MS Excel MVP
M Marcelo Jul 4, 2006 #3 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:
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: