What is the correct format to use when inserting a date in Excel?

asked Jun 21, 2023 225k views

10 votes

What is the correct format to use when
inserting a date in Excel?

7.7k points

Please log in or register to add a comment.

6 votes

Answer:

Dates are whole numbers

Usually, when you insert a date in a cell it is displayed in the format dd/mm/yyyy.

Step-by-step explanation:

AmeliaBR answered Jun 26, 2023

7.8k points

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

8.5m questions

11.2m answers