How to change in uppercase a format date

Copper Contributor

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?

1 Reply

@oencizolivecom 

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.