Power query date format incorrect on Append

[JBK123]

Hi guys,

I am new to using Power Query so hopefully this is easy to resolve.

I have a number of tabs with sales Data which I have created tables for. These tables are then appended into a tab which collates all of the data. My issue is that there are inconsistencies on the date format. All of the dates are stored correctly except for one months sales data which upon creating the Append sheet, which stores as text in a US date format (I am UK based). The original dates in the data table isn't stored as text so I am confused as to why only one of the tabs is converting to text upon appending the data.

Any help is appreciated.

 

[sandy666]

try:
Date column
Left Top corner
Using Locale
- Data Type (==>> Date)
- Locale (==>> choose correct locale)