Is Excel kidding me with ” ‘ ” ?

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!

15 Comments

  1. xxx says:

    I like it when people get together and share ideas.
    Great blog, stick with it!

  2. Hey, I think your site might be having browser compatibility issues.

    When I look at your blog site in Ie, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads up!
    Other then that, amazing blog!

  3. I read this article completely regarding the difference of newest and
    preceding technologies, it’s amazing article.

  4. xxx says:

    Howdy very nice website!! Guy .. Beautiful .. Superb ..
    I will bookmark your site and take the feeds additionally?
    I’m satisfied to find numerous helpful information right
    here in the publish, we need develop more strategies in this regard, thanks for sharing.
    . . . . .

  5. xxx says:

    We are a group of volunteers and opening a brand new scheme in our community.
    Your web site offered us with useful information to work
    on. You have performed an impressive task and our entire community shall be grateful to you.

  6. quest bars says:

    Hi, i think that i saw you visited my web site thus i came to
    “return the favor”.I’m attempting to find things to improve my web site!I suppose its ok to use a few of your
    ideas!!

  7. CharlynPWice says:

    Thank you for the good writeup. It in reality was once a leisure account it.
    Glance complicated to more added agreeable from you!

    By the way, how can we communicate?

  8. I just want to tell you that I am newbie to weblog and definitely loved you’re website. Probably I’m planning to bookmark your blog . You actually come with incredible writings. Thanks a lot for revealing your web site.

  9. NannieRDedaj says:

    I’m no longer certain the spot you will be getting your information, but great topic.
    I must spend a while finding out a lot more or exercising more.

    Thanks for fantastic info I used to be searching for
    this information for my mission.

  10. ChunEShackle says:

    These are typically really wonderful ideas in about blogging.
    You possess touched some pleasant things here. Any way keep up to date
    wrinting.

  11. HongRMcvoy says:

    Heya i am for the first time here. I found this board and that i think it is really
    useful & it helped me out a good deal. I am hoping to present something
    back and aid others such as you helped me.

  12. OdessaLNim says:

    I don’t even be aware of way I stopped up here, but I believed
    this submit used to be great. I will not understand who you’re but certainly you happen to
    be going to a famous blogger in case you aren’t already.
    Cheers!

  13. TobyJCadoy says:

    You really ensure it is seem so easy along with your presentation having said that
    i find this matter to get actually something that I feel I would never understand.
    It appears too complicated and very broad to me.
    I’m looking forward for your upcoming post, I’ll try
    to find the hang from it!

  14. TyreeHBankey says:

    I’m gone to tell my little brother, that he should also go
    to see this blog on regular basis to obtain updated
    from hottest reports.

  15. Great, thanks for sharing this blog post.Much thanks again. Cool.

Leave a Reply

Your email address will not be published. Required fields are marked *