i have a problem with the way Excel 07 interpretes Windows regional settings. With the Excel 07 file open and Windows regional settings set to English (United Kingdom), currencies will automatically format themselves to £0,000.00. When Windows regional setting switched to English (United States) the spreadsheet (still open in the background) will switch automatically to $0,000.00 and so on for French etc. However my colleague in the United States can import files and data and they will remain in their original format. So the question is how do I override the windows regional settings in Excel 2007 (formatting is not an option)? There was a similar question entitled 'Excel 2007 - currency format ' from 'drabsv'. The answer to it didnt solved for individual workbooks but not the underlying problem and was not workable for large numbers of workbooks (many of which are automatically generated).
