Conversion de cellule avec le mois en chiffres en mois en lettres
Constance
-
via55 Posted messages 14395 Registration date Status Member Last intervention -
via55 Posted messages 14395 Registration date Status Member Last intervention -
Hello,
I have an Excel file with a full date (day/month/year). I extracted the years and months as numbers in two separate columns using the formulas =year and =month.
Now I want to translate the month numbers into words, but I can't find a way to do it.
The dates are not in order; it can be from 2018, then 2019, and so on.
The formatting with "mmmm" in the cell doesn’t work: it always shows "January" and I don’t understand how to use the =choose function.
Can you help me?
My month number is in cell M2.
Thank you very much!
Configuration: Windows / Internet Explorer 11.0
I have an Excel file with a full date (day/month/year). I extracted the years and months as numbers in two separate columns using the formulas =year and =month.
Now I want to translate the month numbers into words, but I can't find a way to do it.
The dates are not in order; it can be from 2018, then 2019, and so on.
The formatting with "mmmm" in the cell doesn’t work: it always shows "January" and I don’t understand how to use the =choose function.
Can you help me?
My month number is in cell M2.
Thank you very much!
Configuration: Windows / Internet Explorer 11.0
1 answer
-
Hello
What is the purpose of your extraction and why convert it back to text when you could simply have the month in text and the year in the adjacent cells by using a custom format?
As for CHOOSE, the syntax would be =CHOOSE(M2,"January","February", etc. up to December)
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
