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?
Frederic LE GUEN - MVP
shared this idea
Thanks everyone for showing a lot of passion for adding short month name and short day name to the Power Query in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.
Inbar Privman,
Program Manager, Excel Team
1 comment
-
Ingeborg Hawighorst
commented
And please use the regional settings of the machine that is refreshing the query. So for Germany it would be "Dez" instead of "Dec"