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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Hacked account 0
Template with fields and premade texts.. 0
Need some PWA help 0
How to use/create code in MS Word to calculate age? 0
Mail Merge skipping records/sending one at a time 0
Windows forces me to use one drive 1
Creating a Search using a combo box and then creating a report. 4

Top