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