I just took my midterm exam which is such a kick ass to me. Obviously it has something to do with Excel and it is not a pleasant experience.
In one question which requires me to convert cell format from DATE to Day of the Week. And I fully understand the formula that is “=TEXT(A2, “dddd”)”. However, because I have been busy learning programming languages myself this semester, I wrongly assume that the ” ‘ ” would be as same as ” ” “, which is a quite weird expression, isn’t it?
But no way Excel’s formula is still using outdated rules for programming. How is that possible that it does not support single quote. It took me about half an hour and still unaware of the problem. Only after the exam is submitted did I realize that this could be the problem.
So be careful next time you use the formatting string in Excel. DO NOT USE SINGLE QUOTE!