On Thu, 7 Jun 2007 08:02:00 -0700, 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

I believe you may be under the misconception that the cell format determines
how Excel interprets what you type in as a date. It does not. The cell format
merely determines how the contents of the cell are displayed.

To determine how to parse date input, Excel looks at the "short date" setting
under Control Panel/Regional Settings. This is most likely the source of your
confusion.
--ron