I am currently on the Power Query course, and in lesson 4.13 we learn to make an empty query to make a auto updating calendar.
But the days are in english - mon, tue, wed and so on, months the same.
Is there a possibility to change that into my local format ?
Erik
Hi Erik,
Welcome to our forum!
These date names are system generated based on your locale settings on your PC and Excel. If you want them to show in your local format, you need to change these settings. Presumably your install of Excel is set to English. I hope the link helps point you in the right direction.
Mynda
Hi again Mynda
Thanks - but it turned out that my mistake was not to work in a new worksheet. I had used to course file from a previous lesson
Erik
Oh, ok. Glad you figured it out 🙂