Forum Discussion
Need Help With Capital Letter Date Formatting
Hello, I use Excel with the English language, but I live in a country where Portuguese is the main language. When I try to format date cells to only show the month (as in: "mmmm"), it shows the Engl...
As far as I can tell from an internet search, month names are not capitalized in Portuguese, unlike in English. Excel follows this convention, hence janeiro, feverero etc. There is no custom format that capitalizes the month names.
You can use a formula though: with a date (any format) in D2, enter this formula in E2:
=PROPER(TEXT(D2, "[$-pt-BR]mmmm"))
This can be filled down.