Cell is probably formatted as text. Re-format as Custom, enter mm/dd/yyyy
(or find the equiavalent in the Date category), then re-enter the cell.
(F2/Enter)

"marketerinco" wrote in message
...
I am trying to get a date column to apply a format. For example the dates
are entered as 1/22/2007 and I need them to be 01/22/2007 but when I go
into
dates and select that format it does not apply it. Does anyone know what
I
can do? These are expiration dates that we need to import into our eblast
program for membership renewals.