Japanese Yen Format in Excel

Applying it quickly

To apply the Japanese Yen format can take quite a few mouse clicks.

The macro that does it, on the other hand, is quite simple. Select the range, then run the macro.

Sub JapaneseYen()

Selection.NumberFormat = "[$¥-411]#,##0.00"

End Sub

If you are unsure how to use macros, see the link below.

How to use macros


10% Happier (2014)

Audio Book review.

Narrated by the author – a TV anchor from the US.

Interesting perspectives. Takes a bit to get going as he goes through his back story. Some parts are a bit long winded, but over all, worth a listen.

Meditation is the answer to the question, how can I be 10% happier?