Change mm/dd/yyyy in dd/mm/yyyy

Closed
VISHNU - Apr 4, 2016 at 02:00 AM
 Blocked Profile - Apr 4, 2016 at 09:09 AM
Hello,

i have 250+ entries in excel sheet in format mm/dd/yy
i want to change all in 1 time in dd/mm/yy format

how can I do it.

advise me the simplest formula


1 response

Blocked Profile
Apr 4, 2016 at 09:09 AM
Hi there,

see here: https://ccm.net/forum/affich-878186-how-to-change-oct-26-2015-to-26-10-15#p878197

Highlight all the cells you want to format and follow those instructions.
0