Excel after a MS update
I have a value in cell B21 stating a time of 7:00. This cell is formatted as hh:mm. If I click in the cell and got to the edit bar. I then double click on the hour ‘07’ [Which turns black now] and change the value to 08. I should get 08:00 in that cell. Instead, I get
‘12/08/2024 08:00’ This is because the cell has re-formatted the cell now to dd/mm/yy hh:mm
I am sending the before and after spreadsheet.
I have repeatedly clicked on the whole column ‘B’ and formatted the entire column to ‘hh:mm’ This has never happened before. This seems to be after a latest MS update.
Is there a solution to this or do I now have to repeatedly reformat the cells daily.
|