01 02

How to write chf currency

.. Less

If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.

In this article

Format numbers as currency

Remove currency formatting

What's the difference between the Currency and Accounting formats?

Create a workbook template with specific currency formatting settings

Format numbers as currency

You can display a number with the default currency symbol by selecting the cell or range of cells, and then clicking Accounting Number Format in the Number group on the Home tab. (If you want to apply the Currency format instead, select the cells, and press Ctrl+Shift+$.)

If you want more control over either format, or you want to change other aspects of formatting for your selection, you can follow these steps.

how to write chf currency Forex Tutorial: Reading a Forex Quote and Understanding the ...

how to write chf currency How do you write one million Swiss franc figures? - Answers

Tip: You can also press Ctrl+1 to open the Format Cells dialog box.

In the Format Cells dialog box, in the Category list, click Currency or Accounting.

In the Symbol box, click the currency symbol that you want.

Note: If you want to display a monetary value without a currency symbol, you can click None.

In the Decimal places box, enter the number of decimal places that you want for the number. For example, to display $138,691 instead of $138,690.63 in the cell, enter 0 in the Decimal places box.

As you make changes, watch the number in the Sample box. It shows you how changing the decimal places will affect the display of a number.

In the Negative numbers box, select the display style you want to use for negative numbers.

Useful information relating to the Swiss Franc currency CHF Country: Region: Sub-Unit: Symbol:
1 Franc = 100 rappen

The franc is the currency of both Switzerland and Liechtenstein.
Its name in the four official languages of Switzerland is Franken (German), franc (French and Rhaeto-Romanic), and franco (Italian).

Note: The Negative numbers box is not available for the Accounting number format. That's because it is standard accounting practice to show negative numbers in parentheses.

To close the Format Cells dialog box, click OK.

If Excel displays ##### in a cell after you apply currency formatting to your data, the cell probably isn't wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error. This automatically resizes the column to fit the number. You can also drag the right boundary until the columns are the size that you want.

Top of Page

Remove currency formatting

If you want to remove the currency formatting, you can follow these steps to reset the number format.

  1. Select the cells that have currency formatting.

  2. On the Home tab, in the Number group, click General.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>