How to change Oct 26,2015 to 26-10-15

[Closed]
Report
-
 Blocked Profile -
Hello,

Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell.

1 reply


Hi there!

right click on the cell and click "Format Cells"

select "Date" from the left side and then select the format you require on the right side.

Alternatively you can select "Custom" from the left and type DD-MM-YYYY

If at first you don't succeed; call it version 1.0