changing date value to date

S

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

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)?
Click to expand...

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.
 
D

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.
 
Top