When 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?
Roger Donaldson AIA CSI CDT NCARB
abUsing Datacad since 1986, ver 23.00.02.15 (SE)
http://www.RogerDonaldsonArchitect.com
abUsing Datacad since 1986, ver 23.00.02.15 (SE)
http://www.RogerDonaldsonArchitect.com