The ones which aren't being affected by the formatting are presumably text,
not dates. You may have spaces or other non-printing characters, or you may
be trying to enter dates which don't match your Windows regional settings.
[20/12/07 won't work if your regional settings are loooking for MDY.]

As for your filtering, what criteria are you using for the filter? If you
are looking for text strings including "2003", it won't pick up real dates.
--
David Biddulph

"Melanie" wrote in message
...
I have a spreadsheet with a column that lists dates. To format the column
I
have gone to Edit, Clear, All Formats. Then with the column still
selected
choose Format Cells, Date and choose the dd/.mm/yyyy option. However,
when
I begin entering dates in some are being let justified, some are right
justified. Some dates I enter as 6/5/2003 will appear as 06/05/2003 while
other dates appear without the leading 0.

When I try to filter on the date to find everything that is entered in
2003
for example it does not include the 06/05/2003 in the filtered list.

Any help would be greatly appreciated!
Melanie