If you are already accustomed to Excel, you know that you can format values like any type of currency, from the real (which is the default for us in Brazil) to dollars, euros and kwanzas (current currency of Angola). If you come across currency formatting that you do not like, the process for changing this item is very simple. Let's see exactly what to do:
Modify the formatting of any currency
1. The first step is to select the cells you want to modify.
2. In the image below, we would select all monetary values that are in columns D through O, in the 4 to 9 rows. See below:
3. After that, go to the Home menu in the Number group.
4. Select the arrow in the lower right corner (marked in red in the image above) to open the formatting window of the selected cells, as shown below:
5. Here you can choose the currency option and, in the "symbol" field, select the currency option you want.
6. Excel, depending on which country you are in, will already have preformatted options, but overall, all major world currencies are there for you to use if you wish.
1. Turning from Real to Kwanzas
Follow the step-by-step above by selecting the cells you want to modify the value. Note in the image that the values are in reais. After that, go to the number formatting option, choose currency and in the symbol AOA (Symbol of Kwanza).
This is the preview of the worksheet that should appear for you now.
In a simple, quick and easy way you have modified the values that were once real for kwanzas. Just do this same process for any other kind of value. Let's see more 2 examples.
2. Transforming from Real to Dollars or Euros
The process of turning from real to dollars or euros is even easier, in the initial menu, simply choose the list that appears in the currency symbol next to the% symbol. The dollar and euro options will appear to you as they are more widely used worldwide.
If you prefer to enter the format field, simply click again on the arrow in the lower right corner and follow the step by step, which is always the same, only changes when you need to choose the symbol that will represent the currency in the value inserted in the worksheet.
In the case of dollar, if you look up the value starting with D, you will not find it because the $ symbol comes in front.
In the case of euro, the process is the same, but now with the symbol representing the euro.
Okay, if you follow these steps you will have the currency formatting the way you want it. If you have any questions, just comment below.