What is the data type of date data in excel 2010?

What is the data type of date data in excel 2010?

The data type of date data in excel 2010 is "numeric".

Setting date data in Excel

Date data is a commonly used data type in Microsoft Excel tables. Taking Excel 2010 software as an example to introduce the setting method of date data:

Chapter Step 1: Open the Excel 2010 workbook window and select the cells where you need to set the date and time number format. Right-click the selected cell and select the "Format Cells" command in the shortcut menu that opens.

Step 2, switch to the "Number" tab in the "Format Cells" dialog box that opens, and select the "Date" or "Time" option in the "Category" list. Then select the required date or time format in the date or time type list.

The above is the detailed content of What is the data type of date data in excel 2010?. For more information, please follow other related articles on the PHP Chinese website!