• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Entering Dates and Times

Although Excel records dates and times as serial date values, you don't have to enter them that way. You can manipulate dates and times in your worksheet formulas just as you manipulate other types of values. You enter date values in formats that Excel automatically applies. To enter date values in this way, type the date in one of the following formats: m/d/yy, d-mmm-yy, d-mmm, or mmm-yy. (You can also enter 4-digit years for any of these formats.)

Adjust regional number settings

You can change the default date, time, currency, and numbering settings through the Date, Time, Language, and Regional Options control (or simply Regional Options, or Regional Settings, depending on your system) in the Windows Control Panel. These settings will determine how your date entries are interpreted. For example, with regional options set to Italian, entering a date in d/m/yy format will result in a properly displayed date, but if you enter the same date with regional options set to English, the entry is interpreted as text.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint