Hello,

I am working with both US and german workbooks and need to be able to set the region- or language settings (mainly decimal-separator and thousand-separator) on a workbook level.

I found the setting under "File" -> "Excel Options" -> "Advanced" (see http://blogmines.com/blog/images/upload/2010/03/image_thumb34.png), but that applies to Excel in general (meaning on a system level for all files, not for an individual file).

A way to specify the setting per worksheet would be even better, but setting it per workbook would be ok as well.

Thanks!

Hi

There is no workbook specific equivalent of region/language settings.  However providing your data is either date or currency it is possible to specify the format of ranges within the worksheets to format using regional specific formats.  Look for the Symbol dropdown in Currency and Locale in Dates.  Both are available only in the Format Cell dialog (Ctrl + 1).

This would allow you to specify ranges with German settings and if you wanted US in the same sheet too.

If you wanted regular numbers with out the currency symbol then you would need to devise a custom format to display the figures as you require.

Hope this helps

I had a similar problem.

A possible workaround is to create a second user on your PC (windows level) with the American LAND SETTINGS. Then it will treat all decimal numbers with a period "." and not with a komma ",".

If you need the same file in both settings, then you could store the file in GoogleDrive and download it as the second user.

Decimal komma's "," will automatically be switched to decimal periods "." I tried this out and it works.

Maybe not easy to work with if you have to switch often between the two settings...

Later on I discovered in my case that the program I was working with (QGIS) had the solution built in and provided a "tick box" saying "decimal values with komma"...