Excel Won't recognise as date (mm/dd/yyyy)

[aligahk06]

Dear All,
Please assist in attached sheet,
Excel Won't recognise cell value as a date . I want the date value as (mm/dd/yyyy) format.

Please assist.

Rgds,
ahk

[Fluff]

Cross posted https://www.mrexcel.com/forum/excel-questions/1076435-excel-wont-recognise-date-mm-dd-yyyy.html

[Paul_Hossler]

1. This seemed to be an Excel question, not Access

2. Please read FAQ in my sig #4 about cross-posting

[Paul_Hossler]

1. Select A:E

2. Find-Replace (Control-h) s2018, with s2018 where the 's' is a space

3. Apply number format mm/dd/yyyy

4. Look for any that did not get caught with the Find-Replace like A3 (Oct 1,2018, 2:05 PM) which did not have a space in front of 2018

23142