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 I’m on that cell. Any Ideas?