Forum Discussion
Automatically have Excel format a date when entered without dashes.
How can excel automatically format a date when user enters only numbers without dashes, e.g., 01202023 expected Excel return 01/23/2023 or 1-19-2023. Thank you.
How can excel automatically format a date when user enters only numbers without dashes, e.g., 01202023 expected Excel return 01/23/2023 or 1-19-2023. Thank you.
