Date and Time Stamp

Copper Contributor

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?

1 Reply

@WilliamJOcker 

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.