Lock the regional Settings of an excel file.

knightengale

Board Regular
Joined
Dec 13, 2006
Messages
62
Hello

Is it possible to lock the regional settings of a excel file?

The reason being that I have a excel file that takes information and exports it to a CSV file which is then in the correct lay out to be imorted into the server system
Now this works fine.

But it is nowbeing used in both theUK and the french office.

Now the dates need to be in the UK form of 01-Jun-2008 etc

But when the France office use it it changes this to 01-Juin-2008 etc
Is there any way to lock the file to UK formating?

Thanks for any help

Colin
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

Within a worksheet you can ensure that dates are in a specified locale format if you look at Format>Cells>Number tab and click on the Dates category and use the Locale dropdown.

Similarly, if you use the TEXT function in a cell you can specify a French output for dates even though you may be sat in the UK:

=TEXT(TODAY(),"[$-20C]dd mmmm yyyy")

will ouput "24 Juin 2008" today.
 

knightengale

Board Regular
Joined
Dec 13, 2006
Messages
62
Thanks for that idea.

Problem is that the date options (Format>Num Tab>Date) doesnt give me the
dd-mmm-yyyy option which i need.


I also tried the second one but it just comes out in UK format (im in the UK).

The idea is that when i give the french office the file it stays in the UK format above.

Any idea

Thanks for the help
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Sorry, got the code wrong - should have been:

=TEXT(TODAY(),"[$-40C]dd mmmm yyyy")

It doesn't matter that the exact format isn't there - you can create a custom format.

Just specify that the format is:

[$-809]dd-mmm-yyyy
 

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,774
Members
413,934
Latest member
austinb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top