Hi, For some languages, the decimal and group separator characters are different. For e.g., 3141.59 would be 3.141,59 for German locale and 3 141,59 for French locale. How do I tell excel to use these formats ? The OOXML reference documentation says that '.' is the decimal separator and ',' is the group separator. Can' this be changed ?
My OS locale is set to US English. I do have a test case where I try to set the number format as in java ( i.e. #.###,## for German and # ###,## for French ). But it isn't working. Is there a way to get around this ? Thanks, RK
