Excel and Formatting Dates

  Durko 18:08 10 Jul 2006

Forgotten how to format dates in excel so they accumulate down the column.

e.g. has to be like this down the column

1st January 1950, 1st February 1951, 1st March 1950 .... 1st January 2006

help much appreciated.


  VoG II 18:14 10 Jul 2006

Should it be 1st March 1952? If so:

Tools > Add-ins, make sure Analysis Toolpack is ticked.

With the first date in A1 enter in A2


and copy down as far as needed. Select Column A, Format > Cells and set to display as you wish.

  Noldi 18:35 10 Jul 2006

Is that a correct 1st February 1951? or should that have read 1950.

  Simsy 18:48 10 Jul 2006

Do you mean how each date appears, e.g. as 1st January 1950 instead of, say, 1/1/50 ?

If that is your question...

Select the cells you want to format, selct format from the menu, choose, "Cells" then the "Number" tab...

If there isn't a suitable format in the "Date" section then choose "custom" from the bottom of the options...

In the "type" box put "d mmmm yyyy", (without the quotes)

Note that this will give, for example;

1 January 1950


1st January 1950

The "st", (of 1st,) and "nd", (of 2nd), and "rd" etc, will be missing. I'm not sure how to get those!

Hope this helps, with apologies if I'd misunderstood.



  Durko 20:23 10 Jul 2006

Thanks VOG will do and yes it should be 1st March '52. Other advice appreciated as well.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?