Excel do not see date format in columns after consolidation

[szsmie]

Hey Guys,

I have really strange issue connected to the master tracker, which consolidates data from several other 'individual' trackers.

Once I consolidate data, everything from 'individual' trackers flows to master tracker (they look perfectly the same in terms of view, columns, etc.).

The only problem is, that all dates flowing to master tracker loose their format (even if in each 'individual' tracker dates, as formatted and identified by excel as dates). By this I mean a situation, when excel see each date as text or it sees dates, however changes formatting from European format dd-mm-yyy to US mm-dd-yyyy, meaning that 10-01-2018 (tenth of Jan. 2018) excel reads as (first Oct. 2018).

Is there any easy way to, I don't know, add condition to macro to keep source ('individual' tracker formatting of dates) or any formula to ?

Since, this is my first post here, please let me know if you need any additional information, to identify the issue.

Thanks in advance!

 

[szsmie]

Hmm this time macro worked, but some of the dates are now dates and some of them text

[TABLE="width: 363"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]07 November 2016[/TD]
[TD]07 November 2016[/TD]
[TD]07 December 2016[/TD]
[/TR]
[TR]
[TD]07 December 2016[/TD]
[TD]14/07/2016[/TD]
[TD]15/07/2016[/TD]
[/TR]
[TR]
[TD]07 December 2016[/TD]
[TD]14/07/2016[/TD]
[TD]14/07/2016[/TD]
[/TR]
</tbody>[/TABLE]

Numeric ones are texts, those with lettered months are identified as dates

 

[Fluff]

Were they all dates to begin with, as I can see no reason why they would change?