Nov 11 2020 02:48 PM
I have changed in format cell a date ($-es-MX)dddd d, and the result is in downcase, how can I change it to uppercase?
Nov 11 2020 03:02 PM
There is no custom number format that displays in upper case.
If you have a date in cell A2 (the format doesn't matter), you can use the formula
=UPPER(TEXT(A2,"[$-es-MX]dddd d"))
in another cell, for example B2, to display the date in upper case, for example MIÉRCOLES 11.