Hello Everybody,
I am new here and usually wouldn't bother a forum with my mundane questions, but this one has me baffled.
I am having a simple Formula which reads out the MONTH() and YEAR() out of a cell that is formatted with MMM JJ and adds this to a number (which itself is a VLOOKUP on another cell, but that has little to do with my problem).
Now I am getting a file from Hungary and when I open it (in Germany), the date in the cell is not in MMM JJ Format, but a normal date (i.e. 01.01.2012 instead of Jan 12) and the formula doesn't read out month and year, but simply states #Value!
However, as soon as I enter 01.01.2012 (I simply retype what the person has already typed) myself or even just go into the cell to edit the formula and then hit enter, it works. And yes, my calculation is on auto, not manual update.
I am specifically mentioning the countries because I thought it could have something to do with the date format of the different countries, but I am not sure about that, since both are European countries (same date format) and MMM JJ should be country neutral. Maybe ultimately the error lies in how Hungary enters the data in the first place, but I can't control this.
Any ideas would be appreciated.
Thank you.
Bookmarks