Apr 13 2021 02:00 PM - edited Apr 13 2021 02:01 PM
I have read half dozen plus of posts regarding date format. None have resolved issue.
I'm working with an inherited spread sheet - fixing/updating drop down menus in other columns. Thought I was done but then tested date column. When I key in 41321 I'm getting 02/16/2013 as an example.
I've unmerged heading cells so I can select column. I tried the text to columns, selecting format cells, various date option, tried custom. Per one post added a column to the right of existing but problem carried over to new column.
(sheet 4 has dropdown field contents)
Feel like I'm missing something simple.
Other ideas?
Thought my info would auto populate Windows 10 Ed / MS Office 365
Apr 13 2021 07:51 PM
First, there is more then one date column.
Second, I didn't understand what your problem is.
Apr 13 2021 09:31 PM
Apr 13 2021 09:35 PM
Apr 13 2021 09:41 PM
Apr 13 2021 10:11 PM
SolutionApr 13 2021 10:32 PM
Apr 13 2021 10:47 PM
Apr 13 2021 10:51 PM
Apr 13 2021 10:53 PM
Apr 13 2021 10:11 PM
Solution