Jump to content

Automatic Formatting of Dates and Time


Recommended Posts

Automatic Formatting of Dates and Time

When you enter data, Excel does its best to determine the

type of data you're entering. Dates are a good example of

Excel's intuitive efforts. If you enter a value that

contains a slash (/) or hyphen (-), and that value also

complies with the Windows standard date format, Excel will

interpret your entry as a serial value and format the entry

accordingly. Similarly, Excel will format any value that

contains a colon ( : ) as a time value. Or you can follow the

time value with an A or P, representing AM and PM,


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...