Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Case Sensitive Date Format Rules

I wish the cell formatting rules for dates were case sensitive. For example, the rule "MMM" outputs "Jan" instead of "JAN"

8 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Chris Newman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kenneth Barber commented  ·   ·  Flag as inappropriate

    If you are not doing date/numeric operations on your dates, then you could use the UPPER(TEXT(your date,"mmm")) in a new column. However, I still think that your suggestion is good.

  • Chris Newman commented  ·   ·  Flag as inappropriate

    Zack, I am talking about having a date value (say 1/1/2015) and using a custom format rule to make it visual appear as JAN. Aren't Custom Lists just text values?

    I do this all the time so I can easily pull specific months based on the date value.

Feedback and Knowledge Base