I have an csv file which i have imported into excel from our banking software.

The date has been imported as 180406 being 18 april 2006

if i try to format this into a better format i get a completely diferent
date. Is there an easy way to format this as i have 500 rows of transactions
i need to tidy up?

Thank you in advance
Hervinder