I'm using a text data type (for numerous reasons, using date data-type is not an option) for my Dates columns and they were all running fine but after changing data types and changing them back, they all became serial numbers. Can't figure out how to convert them back to dates whilst still in the text data-type.

Tried using "dd/mm/yyyy/" (works in Excel but not Access?) in the format field for my dates however they stay...