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.
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.
FOLLOW THE STEPS TO CHANGE THE FORMAT OF THE CELLS TO EURO CURRENCY:
FORMAT IS ALWAYS APPLIED TO THE CELLS. AFTER WE HAVE APPLIED THE FORMAT, EVEN IF WE CHANGE THE NUMBERS , IT’LL APPLY THE EURO SIGN.
Normally, when we delete the content from any cell in Excel, the content as well as any symbol contained in the cell is deleted and the cell is ready to be used again but it is not the case with cells formatted with any format.
Look at the animated picture below.
We can check the picture above.
Even after removing the content, whenever we put the new data, EURO SYMBOL was reapplied as the format was changed to the currency.
It can create a lot of problem if we don’t rectify this and remove the formatting.
We can perform the removal operation in two ways.
FOLLOW THE STEPS TO REMOVE THE FORMATTING FROM THE CELLS
FOLLOW THE STEPS TO REMOVE THE CELL FORMATTING SHOWING EURO SYMBOL
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE