strange format change

B

Biff

Hi Folks!

Here's a strange one for ya!

I have a range of numbers formatted as Custom 000. Any
cell in that range that has a number with the leading
zero, the format gets changed from Custom 000 to Special
Chinese(Taiwan)with the Chinese figures however, it still
displays as 000.

Here is a screencap of the format dialogue box:

http://img28.exs.cx/img28/6706/Format.jpg

Can anyone explain why this happens?

Thanks
Biff
 
P

papou

Hi Biff
Not too sure but uncheck Chinese in the Office language settings

HTH
Cordially
Pascal
 
B

Biff

Hi Pascal!

That's why this is so strange, I don't have *ANY* of my
regional settings as Chinese!!!!!

Biff
 
P

papou

Biff
I was not refering to your Windows Regional Settings, I was refering to the
Office language settings where sometimes some languages are "ticked".

HTH
Cordially
Pascal


"Biff" <[email protected]> a écrit dans le message de
Hi Pascal!

That's why this is so strange, I don't have *ANY* of my
regional settings as Chinese!!!!!

Biff
 

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

Top