Jun 30 2021 01:45 PM
I try to format a column to be a date column (example 3/20/20). But when I enter a date it appears as a different one. Help!
Office 365 Windows 10
Jun 30 2021 01:54 PM
Could you provide examples, and/or attach a sample workbook demonstrating the problem?
Jun 30 2021 02:02 PM
Jun 30 2021 02:25 PM
SolutionYou cannot enter dates without separators in Excel - it doesn't recognize 31420 as a date; it sees it as a number.
If you want to be able to enter dates without separators and have them converted to 'real' dates, you need VBA - see http://www.cpearson.com/Excel/DateTimeEntry.htm
Jun 30 2021 02:47 PM
Jun 30 2021 02:59 PM
No, Excel has never accepted dates without separators in any version.
Jun 30 2021 02:25 PM
SolutionYou cannot enter dates without separators in Excel - it doesn't recognize 31420 as a date; it sees it as a number.
If you want to be able to enter dates without separators and have them converted to 'real' dates, you need VBA - see http://www.cpearson.com/Excel/DateTimeEntry.htm