MS Excel / VBA help thread

What do you want to show in the other cells?

You can have the same values, just change the format to display different things.

e.g. A1 displays "12/01/2011" - format as "dd/mm/yyyy"
B1 displays "09:57" - format as "hh:mm"

That's what I'm after , well I can get it to Display that,
But if I want to Filter the dates it then only gives me 2010 and 2011