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


Related Posts with Thumbnails

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