The yen character appears as a backslash in Excel 2004 for Mac when you open an Excel for Windows workbook

Article translations Article translations
Article ID: 870839 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you open a Microsoft Excel for Windows workbook in Microsoft Excel 2004 for Mac, the yen character may appear as a backslash (\).

CAUSE

This problem may occur if the yen symbol is formatted in the MS UI Gothic font in the Excel for Windows workbook. Excel 2004 for Mac does not include this font.

WORKAROUND

To work around this problem, change the font to a Japanese font that is included in Excel 2004 for Mac.

Note You can use any Japanese font that is available in Excel 2004 for Mac.

To do this, follow these steps:
  1. Start Excel 2004 for Mac, and then open the Excel for Windows workbook.
  2. Click the cell that contains the yen symbol, click Format, and then click Cells.
  3. On the Font tab, under Font, click a Japanese font that is included with Excel 2004 for Mac, and then click OK.

Properties

Article ID: 870839 - Last Review: October 6, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Excel 2004 for Mac
Keywords: 
dftsdahomeportal kbprb KB870839

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com