Translations:Basic Excel/100/en

Dates

Excel understands the common date formats used in countries around the world, and when data is entered in a form that it thinks might be a date, it will treat the data as a date unless directed otherwise. This means that date data can be entered in a regular date format, and does not have to be converted to a number (Excel does this and stores that information internally). Although we rarely need to, we can force any number to become a date, as we showed for demonstration purposes in the example above.