Forum Discussion
oencizolivecom
Nov 11, 2020Copper Contributor
How to change in uppercase a format date
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?
HansVogelaar
Nov 11, 2020MVP
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.