Thanks for that analysis p45cal.

Can you explain to me how you were able to visually separate the two, so that I can correct.

Also, this is downloaded data from my bank. It is downloaded as a .csv and I do some editing and formatting before pasting into a master spreadsheet (.xlsx)

I may be inadvertently causing this problem myself. The downloaded date comes in format dd-mm-yyyy. I use Find/Replace to change "-" to "/", and then format the cell as Date (dd/mm/yyyy). This is done in the .csv before pasting to the master spreadsheet. Is this the cause?

If so, what would be your advice for formatting of the date column in the download?

Tommy