Date Format

Closed
Rajasekaran - May 12, 2011 at 02:38 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 12, 2011 at 05:38 AM
Hello,

Friday, May 6, 2011 04:53:43

I want to change this format into 6/5/2011

Kindly help
Related:

1 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 12, 2011 at 05:38 AM
right click on cell,

click on Format Cell

go to Number Tab

Clcik on Custom

in Type write - DD/mm/yyyy

now you got the required format
0