This is because your computer has English (US) settings or something
similar, and expects dates to be entered in mm/dd rather than dd/mm
format. It is one thing to format somethig that is already a date into
a format of choice, it is another to try to enter to Excel a date in a
format not recognized.

Go to Control Panel, Regional Settings and choose your country's
settings.

HTH
Kostis Vezerides

On Jun 7, 6:02 pm, Melanie wrote:
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