ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Setting and Locking the default language for Excel Worksheets? (https://www.excelbanter.com/excel-worksheet-functions/156185-setting-locking-default-language-excel-worksheets.html)

B G Hanson

Setting and Locking the default language for Excel Worksheets?
 
I have several people sharing an Excel 2003 worksheet. One of these people
uses Chinese as her default language. When she opens the worksheet it
changes the form matting of the dates from MONTH/DAY/YEAR to DAY/MONTH/YEAR.
Is there a way I can lock or force the worksheet to only allow English US
formatting?

I can set the formatting for the cell to M/D/Y but once I move to another
cell it reverts back to D/M/Y. If I go back to the cell and look at it, it
says it is formatted for English US with M/D/Y. Then if I go to another cell
it changes to D/M/Y again. If I double click on the cell it show the correct
formatting, but only while Im on that cell. Any Ideas?

--
Bghanson at MNwire.com & bghanson at msn.com


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com