Currency.xls

<div>
Thank you! I just couldn't find it.<br />
<br />
Tim
</div>


<div>
<div class="content wysiwyg-content">
Excel won't format currencies with a Yen symbol (¥). &nbsp;It only formats with the prefix JPY for Japan. &nbsp;How can I make it format a currency with the ¥ sign?
</div>
</div>


Excel won't format currencies with a Yen symbol (¥).  It only formats with the prefix JPY for Japan.  How can I make it format a currency with the ¥ sign?

Formatting Currencies in Excel with the Yen symbol (¥).

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.