Just format it as a date.

A1 = 39124

Select A1

Goto FormatCellsNumber tabDate

Select the format style of your choice

If you want to have the serial number as is in one cell and then have the
date appear in another cell, then:

A1 = 39124

Formula in B1: =A1

Then format as described above

Another, but longer way:

=DATE(YEAR(A1),MONTH(A1),DAY(A1))

Biff

"sadat" wrote in message
...
Hello,
I would be very greatful if anyone can give me a solution to my problem.
My
problem is: what is the formula to convert the date vale (for
example:39124)
to date ( for example: 11-Feb-07)?