Previous Topic Next Topic

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

Closed
Shahadat - Mar 4, 2016 at 10:26 AM
 Blocked Profile - Mar 4, 2016 at 11:02 AM
Hello,

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

1 reply

Answer 1 / 1
Blocked Profile
Mar 4, 2016 at 11:02 AM
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
-1