PPRuNe Forums - View Single Post - Microsoft expect us to be multi-lingual
View Single Post
Old 23rd Mar 2005, 05:33
  #2 (permalink)  
stickyb
 
Join Date: Feb 2000
Location: asia
Posts: 542
Likes: 0
Received 0 Likes on 0 Posts
If you format the cell to 00000 then go back to it as you describe, then the format is special, the locale US and it is a zip code.

What has happened is that your format of 000 just heppens to co-incide with one of the preset Taiwanese codes, so when you go back to look again it can't tell the difference.

Will always happen if a custome format you input co-incides with a preset special.

Last edited by stickyb; 23rd Mar 2005 at 05:48.
stickyb is offline