Jan 09 2019
09:56 AM
- last edited on
Feb 01 2023
09:52 AM
by
TechCommunityAP
Jan 09 2019
09:56 AM
- last edited on
Feb 01 2023
09:52 AM
by
TechCommunityAP
Today, January 9, 2019.
When I open a new workbook, go to cell A1, enter 1/9,
the cell shows 9-Jan
How do I change this?
I am NOT talking about the format cells path.
How do I declare how I want the date to be displayed by default?
Jun 26 2019 08:32 AM - edited Jun 26 2019 08:33 AM
@tlclear8W- I may be wrong, but I think the reason you are getting a lot of views and not many answers is that the only way to determine that is to use the "Format Cells..." -> "Custom" -> "dd/mm/yyyy" (or similar), which you seem to have ruled out. Best regards, Tony