1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Facing #NAME? error to convert date into text data .

Discussion in 'VBA Macros' started by Mohammad Ishaq, Jan 11, 2019.

  1. Mohammad Ishaq

    Mohammad Ishaq Member

    Messages:
    47
    I am learning excel vba.Today i am facing a new problem in my excel sheet.I have different dates on sheet1.
    I want to convert all the dates into text data. For this purpose , i used formula
    Text(value of cell,format,"mmm-yyyy") but it gives me an error #NAME?.

    Please let me help to correct this error.

    I am using office 10 and the file is in attachment.

    Attached Files:

  2. chirayu

    chirayu Well-Known Member

    Messages:
    959
    you forgot the double quotes around the mmm-yyyy in the formula
    Mohammad Ishaq likes this.
  3. Mohammad Ishaq

    Mohammad Ishaq Member

    Messages:
    47
    Thanks . Its Ok.

Share This Page