Month function

G

Guest

This is probably a real simple solution, but how do I disable the function
that automatically sorts the months/days/etc. when I autofill something in a
cell.

i.e. I'm trying to create a column which has JULY in each cell, however,
when I try and drag down JULY to copy it to other cells below, the cells
automatically display AUGUST, SEPTEMBER and so forth.

Thanx
Srain
 
R

Ron Coderre

Try holding down the Ctrl key when dragging.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 

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

Top