changing date value to date
 

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

changing date value to date
 

Format cell as Date


"sadat" skrev:

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

changing date value to date
 

Sat, 21 Apr 2007 22:28:01 -0700 from sadat
:
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)?

Please don't post the same article multiple times.

This isn't online chat: you need to wait a reasonable time (hours, at
least) to give people time to see your query and answer you.


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

changing date value to date
 

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