Share via

Display date code in all caps

Anonymous
2011-05-05T17:18:20+00:00

I am using the date code to have the date on a form input automatically.  However, I would like for the format to be in all caps (MAY 5, 2011).  How can I accomplish this?

Thank you in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-05-05T17:52:47+00:00

    I don't see any native, easy, way to do it. Other apps/languages allow MMM to force all upper, but not excel.

    I found this tip, haven't tried it, that may have the key for your answer:

    Converting Coded Dates into Real Dates

    **http://excel.tips.net/Pages/T007163\_Converting\_Coded\_Dates\_into\_Real\_Dates.html******

    Was this answer helpful?

    0 comments