excel
Posted: Mon Sep 05, 2016 1:24 pmWhen I enter a date in excel 2013, i.e. 9/5/16, it turns it to 9/5/1916 which is annoying.
but in excel 2016, 9/5/16 becomes 9/5/2016 which is what I would expect.
Anyone know the switch to correct this in 2013, I've looked at options, formats, but am forced to enter as 9/5/2016?
but in excel 2016, 9/5/16 becomes 9/5/2016 which is what I would expect.
Anyone know the switch to correct this in 2013, I've looked at options, formats, but am forced to enter as 9/5/2016?