Cell values being stored as Text

Hi all,

I’m having an issue where when changing the time in a cell, Excel stores the value as text rather than a date and messes up the formatting. See below for example.

Steps I took:

• I copied the yellow cell using ctrl+D
• I change the 5PM to 9PM
• This is where the formatting messes up.

Additional info: This problem doesn’t occur when using the browser version, but my colleague isn’t having this issue on the app version either so I would appreciate any help/advice!