|In the first post, it was unclear if the contents of the cells in question had a date or simply a number.|
If the Cells had only a number then the only option, that came to mind, was an =IF function, but that would have required two statements combined.
A daunting task for someone not accustomed to writing them.
I totally forgot about the =CHOOSE function.
When he replied with:
“While changing the way the date is displayed is my ultimate goal, extracting the month number, i.e. 5 = May...11=Nov from another column that I hide within the spreadsheet will also solve my problem.”
That then opened the field to include dates.
My first thought was to use the =MONTH function and a Custom Format of MMMM to get the month spelled out, but that does not work.
I then considered a =TEXT(MONTH(A1),”MMMM”) solution but opted for the shorter and simpler =TEXT(A1,”MMMM”)
that I suggested.