Forum

Local / National va...
 
Notifications
Clear all

Local / National values and text

4 Posts
2 Users
0 Reactions
97 Views
(@erik_h_dk)
Posts: 40
Trusted Member
Topic starter
 

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

 
Posted : 07/05/2020 6:29 am
(@mynda)
Posts: 4762
Member Admin
 

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

 
Posted : 07/05/2020 7:07 pm
(@erik_h_dk)
Posts: 40
Trusted Member
Topic starter
 

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 Embarassed

Erik

 
Posted : 10/05/2020 6:52 am
(@mynda)
Posts: 4762
Member Admin
 

Oh, ok. Glad you figured it out 🙂

 
Posted : 10/05/2020 8:37 pm
Share: