Details 1# selected the cells you want to change as month format 2# right click on the selected cells and click on "Format cells" 3# Select "Custom" under " Number " tab, then type "mmm" or "mmmm" type 4# you will see that the date value is changed to month name Excel Convert numbers to TextEXPLANATION Example Convert number to month name METHOD 1 Convert number to month name EXCEL = TEXT ( DATE (17,B5,1),"mmmm") The formula returns the month's name that is related to the specified number, between 1 and 12 We have manually inserted the first day of a month and any year, in this case using 17For example, if I have the week number "2" in one cell and the year 12 in another, I want Excel to automatically give the month for that week, January (or 1) in a third cell
Convert Month Name To Number Free Excel Tutorial
