Forum Discussion
Change date format in CSV
G'day, I've downloaded a CSV report from out bank account and the date column is in the format dmmyyyy, that is, it's just numbers. Is there any easy way to change it to dd/mm/yyyy without havin...
You could use fomular
=DATE(VALUE(MID(A2,5,4)),VALUE(MID(A2,3,2)),VALUE(MID(A2,1,2)))
Or Power Query
By the way, you could set up local time format in PQ but the out put is text. If the new date need to use for calculation it is better you set up it in Format Cells