May 18 2021 09:40 AM
I used to be able to enter a Date and Time combination into a single cell and it would return a valid date and time: I would enter: 23 June 10:15 into a single cell and it would populate it with a correct date.time number. The cell is custom formatted to d mmm hh:mm. It no longer
May 18 2021 09:48 AM
It still works for me. Have you changed your system date and time settings?
Does the problem persist if you quit and restart Excel? If you restart your computer?
May 18 2021 10:08 AM
May 18 2021 10:48 AM
The number format doesn't matter (as long as it isn't Text).
When you enter something in a cell, Excel asks the operating system whether it recognizes it as a date according to its date/time settings. Apparently, your system doesn't recognize '23 June 10:15'. On an English language system, it should recognize it as far as I know...
May 24 2021 09:08 AM
May 24 2021 09:44 AM
Nice to hear that you found something that works.