Seems simple enough, but how do I change the formatting of the first two to
match the 2nd two. I've already tried various ways to reformat the date
including using the format painter. (The spreadsheet is resistant to change!)

11/30/2004 00:00:00
11/30/2004 00:00:00
12/31/04
12/31/04