Format date with specific regional format
 

I am working in a international group where users have different regional
settings: UK, Denmark, Turkey. I want dates to always show in UK format, even
when regional setting is another country. I need this to work in:
1) ordinary cell format
2) using TEXT() function to construct text expressions using dates.

In Excel 2003, I remember it was possible to insert a regional code number
in brackets into a custom cell format. Is this possible in Excel 2007? Would
this work in the TEXT() function?

Format date with specific regional format
 

In the format code, try prefixing the UK code [$-809] to the date format.
See:
http://www.dailydoseofexcel.com/arch...-of-the-world/


"Fjord" wrote in message
...
I am working in a international group where users have different regional
settings: UK, Denmark, Turkey. I want dates to always show in UK format,
even
when regional setting is another country. I need this to work in:
1) ordinary cell format
2) using TEXT() function to construct text expressions using dates.

In Excel 2003, I remember it was possible to insert a regional code number
in brackets into a custom cell format. Is this possible in Excel 2007?
Would
this work in the TEXT() function?