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?

26 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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