Can I just add (no pun intended) that

1-0.5 is 0.5

"If I enter 1 in a cell (A1), then in cell A2 add the formula (=A1-0.5) I get 0.95"

I presume the OP means 1-0.05