Mohammad Ishaq
Member
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.
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.