Date Format

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

Friday, May 6, 2011 04:53:43

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

Kindly help

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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