I cannot type 24-7 and leave the cell no matter what I change the format to,
it alway shanges back to date.

It is getting very frustrating!

the only way I can stop it is by putting a full stop, and this looks stupid!