robgr
Well-known member
I have just noticed that appear to no longer be able to format the date as dd/mm/yyyy in Excel (Office 365)
A previous document that had a date cell as =TODAY() and which displayed the date as dd/mm/yyyy is now displaying as 20,11,2021 (current format setting)
However, there is no format type for dd/mm/yyyy when I attempt to reformat the cell back to dd/mm/yyyy
This is the same for any empty cell that I attempt to enter a date for and for new worksheets too
This may have changed with 22504.1000
What am I missing?
A previous document that had a date cell as =TODAY() and which displayed the date as dd/mm/yyyy is now displaying as 20,11,2021 (current format setting)
However, there is no format type for dd/mm/yyyy when I attempt to reformat the cell back to dd/mm/yyyy
This is the same for any empty cell that I attempt to enter a date for and for new worksheets too
This may have changed with 22504.1000
What am I missing?
My Computer
System One
-
- OS
- Windows 11
- Computer type
- PC/Desktop
- Manufacturer/Model
- PCSpecialist
- CPU
- Intel(R) Core(TM) i7-1070
- Motherboard
- TUF GAMING B460-PLUS
- Memory
- 32 GBytes DDR4-2667 (1333 MHz)
- Graphics Card(s)
- NVIDIA GeForce GT 1030
- Sound Card
- ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
- Monitor(s) Displays
- Samsung U32J590UQU
- Screen Resolution
- 4k
- Hard Drives
- SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
- PSU
- CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
- Case
- PCS 3601 CASE
- Cooling
- CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
- Internet Speed
- 57/18 Mbps
- Browser
- Vivaldi
- Antivirus
- Kaspersky Total Security