You could just format the cell with the date format you like.

Or you could use a formula like this in a different cell:
=text(a1,"dd-mmm-yy")

The first suggestion will leave the date in the cell. The second suggestion
will return text that looks like a date.



sadat wrote:

Hello,
I would be very much greatful if any one can give me a solution to the
problem. My problem is what is the equation to change the date value (for
example: 39124) to a date ( for example: 11-Feb-07)?

--

Dave Peterson