Formatting Currencies in Excel with the Yen symbol (¥).

Excel won't format currencies with a Yen symbol (¥).  It only formats with the prefix JPY for Japan.  How can I make it format a currency with the ¥ sign?
hthartAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Nah it does format the cell as per Japan currency...enclosed if the file for your reference...to check the format..go to the cell..for instance A1-->Right click on the mouse and format cell..and you would find the formating in currency and yen sign in front...

If you check in custom..thats how it looks like...

[$¥-411]#,##0.00

Saurabh...


Currency.xls
0
 
hthartAuthor Commented:
Thank you! I just couldn't find it.

Tim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.