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

Question

Hello, 

Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell. 

Configuration: Windows 7 / Firefox 44.0

kieferschild · Answer

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

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

1 response

Similar discussions

Subscribe To Our Newsletter!