Windows 10: Date and Time Formatting

Is it possible to format cell in Excel, so that if numbers for date or a time are entered, the date is automatically put in correct format?


Ex. Today is 10/07/2019. So, if I enter 10719, the date will appear as 10/07/19.


Or, if I enter 930, the time will appear as 09:30 in military format.


Thanks

:)

 

Changing Time Format

Hi Mary,

There's a possibility that the set up time format in your computer Basic Input/Output System (BIOS) is military time. To have this checked, you can try to reset the time of your computer through Control Panel. See the steps below on how to do
so:

• Open Control Panel > Clock, Language, and Region >
  Change date, time, or number formats. This would open the
  Region window.
• From there, click on Additional settings at the bottom part. It will open the Customize Format.
• Click Reset; then, OK.

The steps should work; however, if not, we suggest that you contact manufacturer and have the BIOS time checked.

Let us know what happens after doing the suggestions .

 

Display Time and Date on Task Bar?

We appreciate the information you've provided Richard. We would like to ask, does it happen when you use a different user profile on your computer?

We suggest that you check the date and time formats set on your computer. Here are the steps:

• Open Settings.
• Click on Time & language.
• Click on Date & time.
• Under format, click the Change date and time formats link.
• Use the Short name drop-down menu to select the date format you want to see in the Taskbar.
• Use the Short time drop-down menu to select the time format you want to see along with the date.
• Close Settings.

After these steps, see if the date will appear on the Taskbar.

We are eager on getting this resolved for you, we will wait for your feedback.

 

Date and Time

Hi Roman,

Thank you for posting your query on Microsoft Community.

I understand your inconvenience. We will assist you with it.

I suggest you to change the Date and Time format from Control Panel and check. Also select the time zone as UTC-5.00 Eastern Time.


After changing the setting, I suggest you to set “Windows Time” service as automatic. Follow the steps provided below.

• Press Windows logo Key + R key.
• Type services.msc
• Right click on Windows Time service.
• Select Properties.
• Under startup type drop down, change it to Automatic.
• Click on Apply button and OK button.

Restart your computer and check.

Hope this information is helpful. For any further query, feel free to contact us.

Thank you.