We are trying to control the date formatting in Excel cells. The program gives many options to format an inputted date in a cell, and to change format for a column of cells, but no option is shown or accepted to make the format conform to MM-DD. june 14 is turning into J-17; but what is wanted is either 6-14 OR 06-14. In fact, cell not even accepting the data that is input. Trying to type in 6-14, and then moving to another cell forces the just-input information to appear as J-17. This is very far wrong. Does anyone know how to control this?
Windows 10, 64-bit
MS Office 2016
Edited by hamluis, 16 June 2017 - 08:22 AM.
Moved from All Other Apps to Business Apps - Hamluis.