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