A
ams228
Is there a way to create a column of dates in the format of Jan 02, Fe
02, etc through Dec 06 without having to type all that?:
02, etc through Dec 06 without having to type all that?:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Format the column as mmm yy.
In A1, put
=Date(2002,ROW(),1)
drag-copy the formula down to A60
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
In A1, put
=Date(2002,ROW(),1)
drag-copy the formula down to A60
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
K
kkknie
Just type in Jan 2002 in the first cell, then Feb 2002 in the one belo
it. Then put the cursor over the bottom right hand corner of the lowe
cell and look for the skinny plus sign to appear. From there, clic
the mouse button (don't select the cell) and drag down. Excel wil
autofill for you.
it. Then put the cursor over the bottom right hand corner of the lowe
cell and look for the skinny plus sign to appear. From there, clic
the mouse button (don't select the cell) and drag down. Excel wil
autofill for you.
G
Guest
You're gonna LOVE this!
First, type Jan 2002 in the first cell. Excel will
probably autoformat this to be 1/1/2002 or something like
that. Don't worry about that....next, with that cell
selected, Click Format, Cells and in the display that
appears, click "Date" in the left drop down box, so Excel
knows you want to format the cell as a date. In the right
drop down box (same display), look through the list given
and find/click the format you want...probably Mar 98 or
something like that. Click OK to get out of that display.
Your date will now look 'correct' in the cell you
originally typed in.
NOW....the fun part....with that cell selected, find
the 'Autofill' box (a little tiny box that you'll see in
the lower right corner of the selected cell...see it?).
Move your mouse pointer over that Autofill box...it'll
become a skinny black cross pointer instead of an arrow or
a fat white cross. Click and drag down....fun, eh? Hope it
works for you
First, type Jan 2002 in the first cell. Excel will
probably autoformat this to be 1/1/2002 or something like
that. Don't worry about that....next, with that cell
selected, Click Format, Cells and in the display that
appears, click "Date" in the left drop down box, so Excel
knows you want to format the cell as a date. In the right
drop down box (same display), look through the list given
and find/click the format you want...probably Mar 98 or
something like that. Click OK to get out of that display.
Your date will now look 'correct' in the cell you
originally typed in.
NOW....the fun part....with that cell selected, find
the 'Autofill' box (a little tiny box that you'll see in
the lower right corner of the selected cell...see it?).
Move your mouse pointer over that Autofill box...it'll
become a skinny black cross pointer instead of an arrow or
a fat white cross. Click and drag down....fun, eh? Hope it
works for you