Convert a month from number to letter RESOLVED
Solved
agautier
-
mdccm Posted messages 1 Status Membre -
mdccm Posted messages 1 Status Membre -
Hello,
I would like a formula or a function that converts a month given as a number into words. In my Excel table, I have one column where I manually enter the date, and another column that retrieves only the month of this date as a number. I would like this number month to be converted into words (02 => February).
I have already tried customizing the format of the column to "mmmm," but for each line, it displays "Jan-00."
Thank you in advance
Audrey
I would like a formula or a function that converts a month given as a number into words. In my Excel table, I have one column where I manually enter the date, and another column that retrieves only the month of this date as a number. I would like this number month to be converted into words (02 => February).
I have already tried customizing the format of the column to "mmmm," but for each line, it displays "Jan-00."
Thank you in advance
Audrey
the correct function is =CHOOSE((A1);"January";"February"; etc ...)