0
I am having a problem suddenly with all computers at my place of employment.
If I type a number into a cell (A1), such as "121218" excel is not auto-converting to a date. In addition, when the cell is re-formatted to a "Date" format excel is using the entered number as a date in serial number format and returning the wrong value. "121218" is converted to "11/18/2231".
I can find no way to force excel to accept entries as serial numbers, so I don't think it is a setting, and this happened about halfway through the day today on my own and other PCs on the network. For certain Office 365 updated this morning, however dates formatting were working ok earlier in the day. Tried updating Office again (there was another update ready) and it did not fix the issue.
Pic attached to better illustrate this. I typed "121218" into A1 and then converted the cell format to "Date". As you can see the Sample field returns the date as if the number I typed is a serial date. EDIT: In the pic cell C1 reads: "B2=DATEVALUE..." and should say "B1=DATEVALUE..."
Anyone else experiencing this?
Works like that here as well. – Michael Frank – 2019-03-13T00:30:31.277
3What you are experiencing now is normal behavior. The behavior you were experiencing earlier, where you could type in a 6 digit number and have excel convert it to a date, is usually because someone has installed an event-triggered macro to do that. Perhaps some add-in was uninstalled or changed during the day. – Ron Rosenfeld – 2019-03-13T00:49:17.430
1I am at a loss to understand. You type in the number 121,218 (but without the comma) and in the past, excel was under the impression this was not a number, but rather a date? As you said, it was not until after the cell was reformatted to be a date cell. When I type in a date I use
/
or-
and doing so in my 365, Excel sees it as a date even in a non formatted cell. – Ted D. – 2019-03-13T00:54:44.817perhaps the update broke the add-in/trigger – Ted D. – 2019-03-13T00:56:18.020
Are you IT for your organization and looking for more expert opinions, or are you staff? If you are not IT for your org, you should probably ask them about this. They will be aware of the specifics of your setup and may be able to re-enable any plugins unique to your setup, or advise you whether or not the behavior is normal. – music2myear – 2019-03-14T21:44:03.673