I am receiving excel models from a European colleague. The models contain many date fields and many formulas based on these dates (vlookups, sumifs, ifs, etc.). However, when I open the file many of these formula cells are #VALUE! - I believe because the dates they reference are in European format ("24.04.09" for April 24, 2009) and thus my US version of excel does not recognize them as dates.
Is it possible for me to change an excel or computer setting so my US version of excel 2007 can recognize these as dates automatically (i.e. without going through the model and manually converting the dates myself). The models are huge with dates scattered throughout, so finding and converting all dates to US format manually would take me days.
Thanks in advance for any help!
Bookmarks