Date and Time Formats in Excel

Date & Time Formats in Excel

MS Excel supports multiple pre-defined as well as custom formats for Date and Time.

To set/change the Date and Time format, follow the steps below:

1. Enter a date and time value in cell A1

cell A1

2. Right click on the cell having date and time value and select Cell Format from the context menu

format cells

In first demonstration, we will set the value to date only

1. On Format Cells window, select Date from Category and under Type section, select dd-mmm-yy format

date

2. The output would set the value to Date only format

set the value to Date

In second demonstration, we will set the value to time only

1. On Format Cells window, select Time from Category and under Type section, select hh:mm:ss format

time

2. The output would set the value to Date only format

set the value

In final demonstration, we will set a custom value of date and time both

1. On Format Cells window, select Custom from Category and under Type section, type dd-mmm-yy hh:mm:ss in the type textbox

custom

2. The output would set the value to Date and Time format

value to Date and Time format

Search

Shortcodes Ultimate

 
Follow Us
 
BGP