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


--
louisp
------------------------------------------------------------------------
louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880
View this thread: http://www.excelforum.com/showthread...hreadid=511142