Results 1 to 4 of 4
  1. #1

    date formats in Excel

    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

  2. #2

    date formats in Excel

    This may or may not help you. I use time groups in a similar manner for a two hour period 08-10 or 16-18. If you select the drop-down box in the number section, select "More number formats...", then select "Custom", you can make a format 00-00. Then the number will always display as whatever four digits you type in. If you type in 623, it will display 06-23. Not exactly a date coding, but may be useful to you.

  3. #3

    date formats in Excel

    This may or may not help you. I use time groups in a similar manner for a two hour period 08-10 or 16-18. If you select the drop-down box in the number section, select "More number formats...", then select "Custom", you can make a format 00-00. Then the number will always display as whatever four digits you type in. If you type in 623, it will display 06-23. Not exactly a date coding, but may be useful to you.

  4. #4

    date formats in Excel

    Sure. So along the ribbon in the numbers section, when you click the drop down menu, "More Number Formats..." is below the the scrolling options. This opens the "Format Cells" window (there are plenty of different way to open this window). Once there, select the "Number" tab. Under "Category", select "Custom". Then, in the text box under "Type", type 00-00. It will save as a custom option unless you delete it in the future. To select it again, highlight the cell(s) you want, go back into the "Format Cells" window, select "Custom", then select "00-00" from the menu under "Type".



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •