EURO IS A CURRENCY SIGN WHICH DENOTES THE EURO CURRENCY MAINLY USED IN EUROPE.
There can be different ways of creating a EURO symbol in your sheet in Excel.
If you need the EURO SYMBOL for now only, you can just copy this symbol from here and use it in your sheet.
Google is a great tool for a lot of our requirements. We can use it to find out our symbols too. It ‘ll save us a lot of time.
This is the easiest method of inserting a EURO SYMBOL IN EXCEL.
It is easy because it is fast, and we don’t need to remember anything for this.
THE ONLY REQUIREMENT FOR THIS METHOD IS THE AVAILABILITY OF INTERNET.
Here are the steps.
We just discussed how we can find copy and insert a symbol by searching it in google. Now let us move to next method.
If we don’t need to change any font etc. of the EURO symbol , we can find, copy and insert an image too.
The other method of inserting a EURO SYMBOL is using the SYMBOL INSERTION FACILITY from the SYMBOL TABLE.
There is a complete table in the MICROSOFT EXCEL having a full fledged list of a big number of symbols from where we can choose the symbols we like. Follow the following steps to insert the symbol in the Excel using symbol dialog box. But we have a problem with the EURO symbol.
The symbol will be inserted in the selected cell.
We already learnt to insert a EURO SYMBOL using the google , image and symbol dialog box.
We can also insert the EURO SYMBOL using the functions present in the EXCEL.
As we know that all the characters are given the ASCII codes and the characters which are not in the ASCII table are given UNICODE.
Luckily Euro is present in both.
So, we can make use of CHAR FUNCTION as well as UNICHAR FUNCTION to insert EURO SYMBOL in EXCEL.
THE ASCII CODE OF EURO IS 128 AND UNICODE OF EURO IS 20AC WHICH IS EQUIVALENT TO 8364 IN DECIMAL. [ WE NEED DECIMAL VALUE IN UNICHAR FUNCTION ]
* HEX2DEC will convert HEXADECIMAL format TO DECIMAL FORMAT.
The following picture shows the result.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE