Date Format

Closed
Rajasekaran - 12 May 2011 à 02:38
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 12 May 2011 à 05:38
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 7 February 2011 Status Contributor Last seen 30 September 2013 120
12 May 2011 à 05:38
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