Lock the regional Settings of an excel file.

[knightengale]

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

 

[Richard Schollar]

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]

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]

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

 

[knightengale]

Perfect that worked

Thank you for all your help .