Decimal symbol changes from "comma" to "period"

[Vidar]

Hi all

I'm puzzled with this.

In Norway we use comma "," instead of period "." between the integer and decimalpont of a number.
I use a formula to divide two numbers with critereias, to calculate 20 000 rows.
=SUMIFS(SumRange;Criteria Range1;Criteria1;Criteria Range2;Criteria2)/SUMIFS(SumRange;Criteria Range1;Criteria1)

This works ok. But then i convert the result to number, checking that it has the correct format the number is aligned to the right).
Saves the file and close it. When I open the workbook the numbers has been changed to "General" format, and the decimal has changed from comma to period.
From this: 0,8634 to 0.86343612. The numbers in the other columns are ok with the correct decimal symbol, but this one changes.
Have tried to convert it back to numbers and saved it. When I open it again, the same thing happens again.

Vidar

 

[crazypabs]

may I recommend the following as a point of reference...
HOW TO: Change Date, Time, Number, and Currency Value Displays in Windows XP

 

[Vidar]

It was an add-in from Aspentech that caused the "syndrom". Once I deactivated it, the problem disappeared.