May 24 2023 10:14 AM
I am trying to correct the visual data for a date stamp. I selected the short date; however, when I enter a date, it shows as a 5-digit number. How do I correct this to show the actual MM/DD/YR?
May 24 2023 12:55 PM
Select the range with time stamps.
On the Home tab of the ribbon, click the Number Format drop down and select one of the date formats.