SpellNumber European Euros, a manually created function in using VBA coding to displays a given number in words with European Euros as currency.
There is no SpellNumber function in excel. Microsoft has given a code for SpellNumbers USD. You need to manually create this function in the workbook following some easy steps.
Using SpellNumber will display $1,234.50 in the form of “Dollar One Thousand Two Hundred Thirty-Four and Fifty Cents” in the destination cell.
Whereas using SPellNumber European Euros will display ¥ 1,234.50 as ” One Thousand Two Hundred Thirty-Four Yen and Fifty Sen”.
We have done minor editing in the code provided by Microsoft to display the text in Euros and Cents.
You can also check other spellnumber function like SpellNumber Japanese Yen, SpellNumber Great Britain Pound SpellNumber Without Currency, SpellNumber for UAE Dirhams, SpellNumber Saudi Riyals & SpellNumber Indian Rupees.
Step by Step process to create SpellNumber Function for European Euros is given below.
How To Create SpellNumber European Euros Function
1: Open a new Excel workbook.
2: Go to the Developer Tab.
3: Click on “Visual Basic” on the top left corner of the ribbon.
4: On “Insert” Tab, Click on “Module”. This will open a new module sheet.
5: Copy the following Code into the Module sheet.
Code for SpellNumber Function for EUR (European Euros)
6: Click on “Save” button or press “CTRL + S”
The screen will display the following message:
“The following features cannot be saved in macro-free workbook”.
Click “No” as you have to save the file as a macro-enabled workbook.
7: “Save as type” must be selected as “Excel macro-enabled workbook”.
SpellNumberEDP Function for Euros is now added to your function list. Please note that this function will be available in this workbook only. Follow the same steps and paste the code in another workbook.
Make sure you follow the below steps when you open any macro-enabled workbook.
A Security Warning as shown will appear below the ribbon:
Select “Enable this content” & Click “OK”. If you don’t do this any added function in excel workbook will not function properly.
How To Use Spell Number Function For European Euro?
- Insert your desired numbers in Column A which you want to convert to words in Euros.
- Select the function as =(SpellNumberEDP(cell reference), “EUR”) in column B
The second parameter is not case sensitive so you can enter either “EUR” or “eur”.
- Using Fill Handle, copy the same formula to Column B. It will display the numbers as shown below:
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries or suggestions please share in the comment section below. I will be more than happy to assist you.