Try this:

=--TEXT(A1,"00\/00\/00")

Format as Date

--
Biff
Microsoft Excel MVP


"Don" wrote in message
...
I get a file that has a date but it gives it to me as a number like
1/15/2009
would be 11509 in the cell. Is there a way to take that value and format
it
to know it is a date either by having another cell help format it? Note
that
if the date is like 1/08/09 then the number would be 10809...