I have date entered in a cell as 7/12/2010 12:00AM but I want to to display as 12-Jul AM. I don't want to actually see the time. 7/12/10 AM would also be acceptable,
Is this possible?
Thanks a lot!
I have date entered in a cell as 7/12/2010 12:00AM but I want to to display as 12-Jul AM. I don't want to actually see the time. 7/12/10 AM would also be acceptable,
Is this possible?
Thanks a lot!
Last edited by papaexcel; 07-13-2010 at 10:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks