So , we have discussed the different ways to INSERT EURO SYMBOL IN GOOGLE SHEETS. But what about the situation when we are creating any Accounting report and we need to format the cells to show the EURO SYMBOL in front of every number which can be denoted as a currency.
As we know the spreadsheets are used by accounting people a lot. There is always a provision of using the currency symbols separately and so is found in the google sheets to.
In this article, we’ll learn to format our cells such that a EURO SYMBOL is visible before every number or figure entered.
Inserting the EURO symbols in front of numbers or currency
€ 45 + €67 = €112
This type of calculations are more informative and the nicest thing about them is that they never interfere with our calculations yet they stick to the number.
A small sample of calculation is shown below which is created in the google sheets only.
The table shows a EURO SIGN against every figure, but we haven’t inserted it using the other procedures but just formatted our cells to show the currency symbol.
We’ll learn the method further in the same article.
There are two options of formatting the cell for EURO CURRENCY FORMAT.
Let us take an example to apply EURO BEFORE NUMBER in the following cells.
The table contains price, taxes and total amount but we haven’t applied any currency format in the cells.
Now , let us try to apply the EURO symbol before every cell.
Follow the steps to apply EURO SYMBOL in front of every cell.
Select the cells where we want to apply the EURO CURRENCY FORMAT.
The Currency Format Button is located in the Toolbar itself as shown in the picture below.
THE FORMAT AS CURRENCY BUTTON WILL FORMAT THE SELECTED CELLS INTO CURRENCY FORMAT IMMEDIATELY AS PER THE LOCALE SELECTED.
The following picture shows the button location for FORMAT AS CURRENCY option.
FOLLOW THE STEPS TO SET THE FORMAT AS CURRENCY OPTION [ EURO ]:
A EURO symbol will be applied in front of all the numbers in the selected cells.
The following picture shows the result.
If we want to use the currency format randomly and don’t want to change the locale, this method can be used easily.
FOLLOW THE STEPS TO CHANGE THE FORMAT OF THE CELLS TO EURO CURRENCY:
We can reach the same place using the MENU OPTIONS too.
Go to FORMAT > NUMBER >MORE FORMATS> MORE CURRENCIES.
The process is shown in the picture below.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE