Convert number of month to name of month in Excel

Lets assume Date in A1 cell then use the follwing formulas
  • =TEXT(A1,”MMMMM”)
    for the first letter of the month
  • =TEXT(A1,”MMMM”)
    for the month spelled out completely
  • =TEXT(A1,”MMM”)
    for the 3 letter abbreviation of month

17 comments :

  1. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    angularjs-Training in chennai

    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    ReplyDelete
  2. This post is much helpful for us. This is really very massive value to all the readers and it will be the only reason for the post to get popular with great authority.
    AWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery


    ReplyDelete

  3. Title:
    Best Oracle Training Institute in Chennai | Infycle Technologies

    Description:
    Set your career goal towards Oracle for a wealthy future with Infycle. Infycle Technologies is the best Oracle training institute in Chennai, which gives the most trusted and best Oracle Training in hands-on practical training that will be guided by professional tutors in the field. In addition to this, the mock interviews will be given to the candidates, so that, they can face the interviews with full confidence. Apart from all, the candidates will be placed in the top MNC's with a great salary package. To get it all, call 7502633633 and make this happen for your happy life.

    Best training institute in chennai

    ReplyDelete
  4. Infycle Technologies, the best
    software training institute in Chennai
    offers the best Python training in Chennai for tech professionals and freshers. In addition to the Python Training Course, Infycle also offers other professional courses such as Data Science, Oracle, Java, Power BI, Digital Marketing, Big Data, etc., which will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7502633633 to get more info and a free demo.

    ReplyDelete
  5. Best Software Training Institute in Chennai | Infycle TechSet your career goal towards the software industry for a healthy future with Infycle. Infycle Technologies is the best software training institute in Chennai, which offers 100% hands-on training, guided by professional tutors in the field. After the training, the mock interviews will be given to the candidates, so that they can face the interviews with full confidence. Apart from all, the candidates will be placed in the top MNC's with a great salary package. To get it all, call 7502633633 and make this happen for your happy life.
    BEST TRAINING IN CHENNAI

    ReplyDelete
  6. Finish the Selenium Training in Chennai from Infycle Technologies, No.1 software training institute in Chennai which is providing professional courses for students, freshers, experienced, and tech professionals. We provide courses like DevOps, Artificial Intelligence, Cyber Security, Python, Oracle, Java, Power BI, Digital Marketing, Data Science, etc. with the best trainers receiving amazing training for the best career. For more details and demo classes call 7504633633.

    ReplyDelete

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger