I've got some data from Taiwan in a .csv spreadsheet, but the dates are all in their patriotic calendar like this:
102/06/05
102/06/22
102/07/01
...
I need them in Gregorian format like this:
2013/06/05
2013/06/22
2013/07/01
...
The conversion is simple, just add 1911 to the year. Any ideas of a simple way to it in Excel?