Japanese Yen Format in Excel

Post author:Neale Blackwood
Post published:29/10/2015
Post category:Excel 2003 Excel 2007 Excel 2010 Excel Blog Macros
Post comments:0 Comments

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

Getting the Week Number From a Date in Excel

Post author:Neale Blackwood
Post published:27/10/2015
Post category:Excel 2013 Excel Blog Functions
Post comments:2 Comments

Excel has had a week number function for many versions, but Excel 2013 added a new week number function that complies with the ISO 8601 standard week number. (more…)

Adding years or months to a date in Excel

Post author:Neale Blackwood
Post published:15/10/2015
Post category:Excel 2007 Excel 2010 Excel 2013 Excel Blog Functions
Post comments:0 Comments

When working with loans or leases, it is common to have to add a number of years to a start date to determine the end date. An Excel function can automate that process. (more…)