Feedback by UserVoice

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

Add short month name and short day name in Power Query

In Power Query, you can convert a date in year, month, day, first day of the month, day of the week, .... You can also convert a date in month name or in day name.

But there is no option to convert a date with the short name (Jan, Feb, Mar, ...) and the same for the day (Mon, Tue, Wed, ...)

Is it possible to add these options on the ribbon?

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

We’ll send you updates on this idea

Frederic LE GUEN - MVP shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

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

    And please use the regional settings of the machine that is refreshing the query. So for Germany it would be "Dez" instead of "Dec"

Feedback and Knowledge Base