I am using the following code to format a range to show numbers in Japanese YEN. It works fine on English version of Excel 2010 but does not display ¥ correctly on a system running Japanese version of MS Excel 2010. Can someone please help me out here? Thanks!

Please Login or Register  to view this content.
This is what the output looks like:
･ 110,000
･ 111,664
･ 550,000
･ 558,320

Also attached is an image for clarity.
JPY.png