Check cell contents

Question

I have a number of spreadsheets and need to check that the format "01 Jan 1915" is correct in every cell.
As some of these Spreadsheets can contain 50,000 lines, or more, is there any way of checking that every cell is in the correct format without having to physically scroll through.