Issue with date not being recognised as a date by excel

[chrisellis250]

Hi all,

On the attached workbook, there are 2 sheets:

- Sheet 1 - Column B shows the date correctly, which is recognised as a date by excel.

- Sheet 2 - Column B shows the same as sheet1, but it is not recognised as a date by excel.

I attempted to change the data in column B sheet 2 to a date, by chaging the number type from text to date and replaced the . with / - however this did not work correctly and created numerous issues - such as showing the date the opposite way, i.e. 06/01/20 was shown as 1st June, whereas in the UK that is the 6th January.


Can someone assist me with a way to get the date as shown in Sheet2 ColumnB to be recognised as a date throughout?

Kind Regards,

Chris

[PaulM100]

Select B column then go to Data, Text to Column, Next, Next, Select Date and in dropdown DMY(day, month, year), Finish

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[chrisellis250]

Hi Ali,

I have now changed my title.

Many thanks,

Chris

[AliGW]

That's more like it - thank you.