Saturday, 2 November 2013

Print your own diary - Excel hack for international (non-English) users

I received an email from Pedro Peres that might be of interest to users of non-English versions of Excel. Here's what Pedro says:

As a big thanks for your great work i attach here an update to you wonderful xls version of DatesSourceFilo.xlsx (from
 As i am portuguese i was struggling to make it work with my language. When i open in excel it reads the Windows local region settings and the formulas do not work correctly.If my "Region And Language"
settings are set to Portugal the year is aaaa for "ano", the portuguese word for year.
 So I found an Italian solution that gets the current local in excel with defined names.
 e.g.: year_symbol is a name defined for =REPT(INDEX(GET.WORKSPACE(37);19);4)
 So now i think it works in every language, you must accept macros for defined names (it has no macros besides that).
 The only update it needs is the ordering column. In portuguese you dont have "st" , "nd", "rd" or "th". So i had it removed. In Portuguese we have "de" like "1 de Janeiro de 2014". I also have put the name of the week in the calendar.

I hope you like it and put it online to help the non english users.
 How to use it*:
1st - open "DatesSourceFilo2.xls"
2nd - go to Region and Language
3rd - change to a different language and see the excel updated 4th - open "Base diary 1 day per page2.docx"
5th - go to Region and Language
6th - change to a different language and see the word updated when you change the record  (next or previous)
 *works in office 2013 version and windows 7
 Best Regards
Obrigado a todos
 Pedro Peres from Portugal

Here are the links for Pedro's files: Base diary (2 PPD) in Word    Excel data source
Post a Comment


Related Posts Plugin for WordPress, Blogger...