R4+Z
23rd Mar 2005, 01:26
I recently ran into an unusual one on Excell 2002.
If you format a cell as custom and set it to 000 when you enter data eg 20 it displays as 020. All well and good but if you then go to look at the format of that cell again it has miraculously changed to special with chinese symbols for the setting and a box has appeared saying locale (location): and in that box it says Chinese (Taiwan). if you then change it back to english the formatting returns to general so it is impossible to check what it is set as unless you read Taiwanese (yes it does show you a sample but if you saw an entry and went to check how it was set, the example is only going to show you what you already know).
I contacted microsoft about this and they claim it does this by design and want to charge me $50.00 to even discuss it at a technical level.
Is it just me or would you expect an entry made in english to remain in english?
:confused: :confused: :confused:
If you format a cell as custom and set it to 000 when you enter data eg 20 it displays as 020. All well and good but if you then go to look at the format of that cell again it has miraculously changed to special with chinese symbols for the setting and a box has appeared saying locale (location): and in that box it says Chinese (Taiwan). if you then change it back to english the formatting returns to general so it is impossible to check what it is set as unless you read Taiwanese (yes it does show you a sample but if you saw an entry and went to check how it was set, the example is only going to show you what you already know).
I contacted microsoft about this and they claim it does this by design and want to charge me $50.00 to even discuss it at a technical level.
Is it just me or would you expect an entry made in english to remain in english?
:confused: :confused: :confused: