If after you use the format painter, you double-click on one of the dates at
the top and hit enter, does it change the format?

"laralea" wrote:

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