SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do you change the date format for all the dates shown in a site to be in the format "day month year"? So that today would show as "24 October 2011"? I've gone to Site Actions > Regional Settings, but not sure what to select on this page. Thanks.

share|improve this question
did you find answer to this post? we have the same issue. – user11731 Oct 31 '12 at 17:57
up vote 2 down vote accepted

I don't think it's possible. You could create a webcontrol which shows the date like you want it. In case of a date in a list, you should use a content query webpart with a custom xsl

If you want to show the date like you want it in a list:

Create a Date column(Call Date1), leave it on the default view
Then create another column for your text version date
Call it what ever you want "Date 2" or something
Select Calculated (calculation based on other columns) type
Down in the Formula window insert this formula: TEXT([the name of your number date column goes here between the square brackets],"mmmm-dd-yyyy"), Click "Ok", essentially you have the following in brackets =TEXT(Date1,"dd-mmmm-yyyy")

share|improve this answer

Actually it is possible, although a bit hacky. Check-out this blog post:

I have been using this method a couple of times and it has worked fine in my cases.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.