Format dates as French

[JugglerJAF]

I have an Excel file which is currently used in English speaking countries and a column of dates is formatted as dddd dd/mm/yyyy

For example a date of 01/04/2013 (1st April 2013) would be formatted to display as Monday 01/04/2013

The problem I have is that this file is now going to be used in a French speaking market, so for the "ddd" part of the format, I need it to display as Lundi 01/04/2013 (the French for Monday being Lundi)

Is it possible to set date specific formatting based on different countries (I'm using Excel 2007)? I know that in Word, you can use the "Set Language" option on the Reviewing tab, but that options isn't available in Excel.

I only have the problem with French at the moment, but this file could end up being used in a number of different countries, so I need an approach whereby I can specify a country and have the day part of the date formatted using the language of each country.

 

[Firefly2012]

Hi

You could format these cells using a custom number format of:

[$-040c]dddd dd/mm/yyyy

 

[dave3009]

You aren't going to be able to set one format for 'any' country, there are individual formats for each language, calendar type and character type, see Microsoft for more info.

Regards

 

[JugglerJAF]

Thanks folks. I'll set up some macros to apply the formatting for all the countries we use (based on a "country code" field) and apply the appropriate code from the Microsoft website.

Just what I needed. Cheers.