Forum Discussion
amkdil
May 11, 2023Copper Contributor
Excel (365) date format (in cell) won't change from number of days since 1/1/1900
Hello. I seem unable to change the date format from the number of days since 1/1/1900. I have tried all different date formats, and despite the actual date showing correctly in the formula bar, t...
HansVogelaar
May 11, 2023MVP
Activate the Formulas tab of the ribbon.
If the Show Formulas button in the Formula Auditing group is highlighted, click that button.
- amkdilMay 11, 2023Copper Contributor