Date

%3CLINGO-SUB%20id%3D%22lingo-sub-2770840%22%20slang%3D%22en-US%22%3EDate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770840%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20enter%209%2F21%2F2021%20it%20changes%20it%20to%20Sept-21.%26nbsp%3B%20Just%20started%20happening.%26nbsp%3B%20Any%20advise%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2770840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

When I enter 9/21/2021 it changes it to Sept-21.  Just started happening.  Any advise?

 

1 Reply

@norinecardinalgmail 

 

That's a matter of formatting of the cell. Up in the "Home" toolbar, you should be readily able to change the date format to "Short Date"

  1. Highlight the cell or cells you want to work on.
  2. Then click on the small downward carat next to the word "Date"
  3. mathetes_0-1632238962727.png
  4. Then select "More Number Formats" down at the bottom of this screen
  5. mathetes_1-1632239013900.png
  6. Then "Date" from the category list on the left (it probably will appear as the default selection) and select the format you want.
  7. mathetes_2-1632239109300.png