Excel and Formatting Dates

  Durko 18:08 10 Jul 06

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 06

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 06

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

  Simsy 18:48 10 Jul 06

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 06

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 7 simple tips to get more out of…