Power query date format incorrect on Append

JBK123

New Member
Joined
Mar 20, 2018
Messages
3
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.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
try:
Date column
Left Top corner
Using Locale
- Data Type (==>> Date)
- Locale (==>> choose correct locale)
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top