changing date value to date
 

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)?

changing date value to date
 

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)?

changing date value to date
 

Sat, 21 Apr 2007 22:26:01 -0700 from sadat
:

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)?

There is no formula, because there is nothing to convert.

Select Format | Cells | Date.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/