Date conversion

[goodmachine]

Hello,

How can I modify a date with the time stamp and time zone to just a normal date.
For example, Thu Jan 17 12:44:31 PST 2013. I would like to just show

January 17, 2013. Is this possible?

Thanks,

goodmachine

 

[shg]

=--(MID(A1, 5, 6) & ", " & RIGHT(A1, 4)) and format as you like.

 

[Rambo4711]

Try to format the cell as date : [$-41D]D MMMM, YYYY;@

 

[sdsurzh]

Hi,


Suppose if you have date in A1 please try the below formula.


=TEXT(A1,"mmmm dd,yyyy")


Thanks,
SK