Forum Discussion

oencizolivecom's avatar
oencizolivecom
Copper Contributor
Nov 11, 2020

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?

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 11, 2020

    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.

Resources