How do I format a column of calendar dates in Calc?

@ve3oat Presumably, he will want to import further PayPal data. It’s probably best to know how to import it correctly into a spreadsheet.

Solved! Finally! Thanks to EarnestAl, I’ve managed to wrangle this year’s PayPal summaries into a workable spreadsheet. I just couldn’t locate the solution suggested within the time limits to get the work done. But now, 6 years after fumbling with this data every January, I’ve got it figured out. Now I have to be able to remember it come next January!