Excel tries to guess what format you want and will constantly change
them. It's often annoying, as the behavior varies with how you input
things, as you have noticed. Sometimes it seems random.

Change the format manually when it does this.