Format date with specific regional format

[Fjord]

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?

 

[Lori Miller]

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