yeah, half of them are text.
Multiply by 1 to make them numbers, then format as a date
=A1*1
Any chance you could upload it here. I want to see if I can copy and paste it over.
=a1*1 didn't work for me on column D
attached. new column in green
@ChainBreaker started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
yeah, half of them are text.
Multiply by 1 to make them numbers, then format as a date
=A1*1