Changing date formats

Closed
k - Jun 8, 2009 at 04:24 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jun 8, 2009 at 06:17 AM
Hello,I want to know how to change the date of 13/07/2006 in to 07/13/2006?

1 reply

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 8, 2009 at 06:17 AM
go to formatting (press CTRL +1) and choose custom and enter mm/dd/yyyy
0