changing date value to date

[Guest]

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

 

[Guest]

Format cell as Date


"sadat" skrev:

 

[Stan Brown]

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.

 

[Dave Peterson]

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.