Displays date and time serial numbers as date values, according to the type and location that you specify
- Select a cell or a range of cells.
- Right-Click, Select “Format Cells“
- Select “Date”
Or Press “CTRL + 1” and select “Date” Tab
- To specify the Date type, We can change it from the “Type” box
- To specify Date type, According how another language display date, choose it from “Locale (Location)” box