Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I download an excel file which contains chinese characters, but the excel on my macbookpro/osx/snow leopard is not able to show these chinese characters.

However if I copy a chinese character from somewhere and paste it into a cell, it is able to show the chinese character.

What might be going wrong?


share|improve this question

We recently had a similar issue with all Asian fonts in Excel for OSX (Chinese, Japanese, and Korean). The solution that worked for us was to change the font to "Arial Unicode MS". You can do it for just the cells in question or the entire sheet.

Answer originally found from the question chain here:

share|improve this answer

What does appear when you open the file instead of chinese -- nothing or latin characters? If the latter, then it is probably an encoding difference.

What version of Excel are you using?

Is the file available on the internet so one could have a look at it?

You may also want to search/ask in the forums run by the app maker:

share|improve this answer
Welcome to the community! Stackexchange is not like other forums. Answers to questions should actually attempt to answer the question. Your response should have been posted as a comment, and only if the comment actually moves the discussion forward. If you like a question or an answer, simply upvote it or mark it as a favorite to see new answers when they are posted. Also, whilst your answer may theoretically answer the question, it would be preferable to include the essential parts of the article in an answer below, and provide the link for reference. – Philip Regan Oct 7 '11 at 19:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.