0
0
I have an Excel file which checks the date in a specific value and formats it as "mmm-yy". The problem is that I'm in Spain and for the formula to work I need to change manually to "mmm-aa". I want to avoid this step. I got my computer language set to English and the Excel itself is in English, I don't know why it is taking "aa" instead of "yy" PD: I'm using a Mac computer
Santiago Veintimilla
Posted 2019-02-15T13:33:23.410
Reputation: 1
does aa spanish means yy in English? – p._phidot_ – 2019-06-13T10:23:00.803
yes! I still haven't figured a way to get around this. – Santiago Veintimilla – 2019-06-20T08:08:20.283
seems like Microsoft said "NO". and my other useful link is link1 link2 link3 .
– p._phidot_ – 2019-06-20T09:08:58.983(link3 said the source of the problem is not in excel, It's in the Windows setting.) Have a try.. ( : – p._phidot_ – 2019-06-20T09:09:04.123
I'm working on Mac, but I think the problem goes in that direction. Thanks! – Santiago Veintimilla – 2019-06-21T10:05:03.573
if it solves, you may share the answer in the answer post for the benefit of future readers. ( : – p._phidot_ – 2019-06-22T10:17:49.340