Entering Dates in Excel

Stop the full stop

There are only two characters Excel recognises when separating numeric days, months and years in dates. They are the / and – characters.

Please don’t use the full stop as Excel won’t recognise it as a date.

Below you can see examples of using / and – in dates.

 

When you use the full stop Excel won’t recognise it as a date – see below.

Its left aligned and will be treated a text.

Related Posts

Copying a Date Down a Long List in Excel

Two techniques make it quick and easy

There are a number of mouse and keyboard shortcuts for copying. But there is one type of copy that can be frustrating. Copying dates can be challenging because, in general, Excel wants to increment them, not copy them. There is a simple technique to instruct Excel to copy a date.