Recent content by cygnette

I see. :) Will try this out with my data. Thanks for the additional info! That is very helpful of you.

Yup, might help someone else who needs it. Like myself. :) Found this forum when I desperately needed the answer. Might save someone else the frustration. :) I have a little problem with the formatting thing. Cause if you just format, the time is still there, it's just the display that's...

Had the same problem myself. Try this. It worked for me. TO CONVERT 9/1/2011 9:52:00 AM TO "Sep 1" or the like follow these steps. If your data is in B6, use formula below: =TEXT(B6,"mmm d") or =TEXT(B6,"mm/d/yyyy") depending on your preferred date format. Once you get the "Sep 1"...