| Quote: | |  | |
| Don't get me started on the comma, semicolon thing. Bane. of. my. life!
That is, until i found that those things are actually specified on a windows level rather than in Excel...if you want to make friends, add a bit of code that changes all regional settings on the computer (date, comma, currency, thousand seperators etc) when you open the worksheet, then share the document with all your work mates. Happy days. Finally you can discuss a number and be sure what is a decimal point and what is punctuation! | |
| | |
So what are you saying here.
Are you saying write some VB code that on opening the workbook specifies the format of the cells for the dates and number formats so that who ever in whatever langauge reads how it is in their language?