Excel Excel - cell format switches to custom when switching language

L

loupero

Joined
Feb 6, 2006
Messages
8
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - cell format switches to custom when switching language 0
Excel How to add numbers in same cell? 2
Excel How to change the "Short Date" format in Excel? 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Format function with international numbers 2
excel 2003 zero as last decimal 5
How to set date format between different location? 4
Trying to run excel vba code when cell value changes from empty to entered value. 1

Top