Maze Posted November 28, 2016 Share Posted November 28, 2016 how to change the date formate in excel from 01.01.201702.01.2017to01.01.17 ..e t c Quote Link to comment https://forums.phpfreaks.com/topic/302631-how-to-change-the-date-formate-in-excel-from-01012017-to-010117/ Share on other sites More sharing options...
Barand Posted November 28, 2016 Share Posted November 28, 2016 Select date cells and right click Select "format cells" Choose "custom" enter "mm.dd.yy" Quote Link to comment https://forums.phpfreaks.com/topic/302631-how-to-change-the-date-formate-in-excel-from-01012017-to-010117/#findComment-1539767 Share on other sites More sharing options...
Maze Posted November 28, 2016 Author Share Posted November 28, 2016 many thanks for the tipp Quote Link to comment https://forums.phpfreaks.com/topic/302631-how-to-change-the-date-formate-in-excel-from-01012017-to-010117/#findComment-1539775 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.