SpellNumber Japanese Yen is a manually created Excel function using VBA Programming. It displays a given number in words as Japanese Yen.
SpellNumber is not an inbuilt function in excel. Microsoft has provided a code for Spell Numbers for US Dollars. We have to manually create this function manually for every workbook in which you want this function using the VBA Programming.
You can display $1,234.50 = “Dollar One Thousand Two Hundred Thirty-Four and Fifty Cents” with SpellNumber Function.
To display ¥ 1,234.50 as ” One Thousand Two Hundred Thirty-Four Yen and Fifty Sen”, you can you the SpellNumber Japanese Yen Function.
Minor editing has been done to the Microsoft Code to derive the required result.
You can also check spellnumber function for other currencies: SpellNumber Great Britain Pound SpellNumber Without Currency, SpellNumber for UAE Dirhams, SpellNumber Saudi Riyals & SpellNumber Indian Rupees.
A complete step by step process to create this SpellNumber Function for Japanese Yen using the VBA is given below.
How To Create SpellNumber Japanese Yen Function
1: Open a new workbook.
2: Go to “Developer Tab”.
3: Click on “Visual Basic”.
4: Under Insert Menu click “Module” as shown below:
A new module sheet will open.
5: Copy the Code given below and Paste it into the Module sheet.
Code for SpellNumber Function for Yen (Japanese Yen)
6: Click the “Save” button.
The following message will appear: “The following features cannot be saved in macro-free workbook”.
You need to save the file as a macro-enabled workbook as it contains a maco. Click “No” option.
7: Select “Save As”.
8: Choose “Save as type” as “Excel macro-enabled workbook”.
SpellNumberEDP for Japanese Yen is now added to your excel functions. This Function will only be available in this workbook.
To get this function in another workbook, follow the same steps and paste the code in another workbook.
Note: Whenever you will open any macro-enabled workbook, there will be Security Warning as shown below:
Choose “Enable this content” & Click “OK”. Failing to do so will result in non-working of the function in excel workbook
How To Use Spell Number Function For Japanese Yen?
- Insert numbers in Column A.
- In Column B, select the function SpellNumberEDP, cell reference, and YEN in the double quotes as shown below:
The second parameter is not case sensitive. Thus you can either enter “YEN” or “yen”. Both will display the numbers accurately.
- 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.