Change First Letter Capitalization in Dates (In any language)
I was working on a table with dates and I found a hard time trying to capitalize the first letter of a date. I noticed that in english dates, going in the custom format and adding ;@ would do the job. However, I was working with data in portuguese.
I found out a solution, derived from a support post in Microsoft. The solution would be to use this code: =PROPER(TEXT(Cell Selected,"[$-pt-BR]mmm/yyyy")) You would be able to use it clearer in any date format. And to change to the language you're working, I believe you would have to change from the pt-BR part to your language code.
What I ask is that this could be more easily visible because I spent an entire afternoon trying to simple capitalize a date cell. Thus, you can imagine how frustrating this could be.