Nov 07 2023 07:54 AM
I have a spreadsheet started and most of it is working fine. Within the body I have several cells that will not let me enter hours and minutes in the h:mm format. It keeps giving me a message saying that it has to be in decimal format. I have deleted format and I have deleted entire column and copied one that seems to be working. Nothing is working for a few cells here and there throughout the spreadsheet.
Nov 07 2023 08:30 AM - edited Nov 07 2023 08:30 AM
Select such a cell.
On the Data tab of the ribbon, in the Data Tools group, click Data Validation.
Do you see a restriction there?
Nov 07 2023 10:27 AM