Hello,
I am new to this forum. Greetings to all!
I currently have a bug on Excel 2000 (SP3), running on Win. XP SP2. (both are french versions)
Here goes:
I creat a new excel file using English Canada as regional settings. I input some numbers and change the cell format to Number, 2 decimals and with the thousands separator activated and the parentheses (no colour) for negative numbers.
After I switch my regional settings to French Canada, the format of the cell is now custom: "# ##0,00\ _$_);(# ##0,00\ _$)". Not only has the format changed, the width of the cell is now larger than before, and I'm stuck with some ######### in all cells that had the specified number format in english.
The thing is, if I use 0, 1, or 3 decimals (instead of 2), there is no bug... And when I switch back to English Canada, the format for the 2 decimal cells is restored and the display is ok.
Why, oh why? I couldnt find anything on the web, and thought maybe someone here had some ideas...
BTW - When I open the same file on Excel 2003 (SP2) I get the same result...
thank you for any help you might bring...
Louis
I am new to this forum. Greetings to all!
I currently have a bug on Excel 2000 (SP3), running on Win. XP SP2. (both are french versions)
Here goes:
I creat a new excel file using English Canada as regional settings. I input some numbers and change the cell format to Number, 2 decimals and with the thousands separator activated and the parentheses (no colour) for negative numbers.
After I switch my regional settings to French Canada, the format of the cell is now custom: "# ##0,00\ _$_);(# ##0,00\ _$)". Not only has the format changed, the width of the cell is now larger than before, and I'm stuck with some ######### in all cells that had the specified number format in english.
The thing is, if I use 0, 1, or 3 decimals (instead of 2), there is no bug... And when I switch back to English Canada, the format for the 2 decimal cells is restored and the display is ok.
Why, oh why? I couldnt find anything on the web, and thought maybe someone here had some ideas...
BTW - When I open the same file on Excel 2003 (SP2) I get the same result...
thank you for any help you might bring...
Louis