Hi All,
I am having some issues with getting Excel to recognise that the data in one of my columns is actually a date, but is formatted as DAY, 01/01/2019. I have created a custom format for the column, which is ddd, dd/mm/yyy but this doesn't appear to have helped...
I don't want to reformat the column as the data is being pulled from an RSS feed via Power Query, so any help in getting this column to be recognised as a date would be great as i need to be able to sort by date on it
Thanks in advance
I am having some issues with getting Excel to recognise that the data in one of my columns is actually a date, but is formatted as DAY, 01/01/2019. I have created a custom format for the column, which is ddd, dd/mm/yyy but this doesn't appear to have helped...
I don't want to reformat the column as the data is being pulled from an RSS feed via Power Query, so any help in getting this column to be recognised as a date would be great as i need to be able to sort by date on it
Thanks in advance