Your "'non-working" cells is formated as text. When you copy it
elsewhere you're copying the formatting also so the new cell is now
formatted as text.
Copying a "working" cel into a non-working cell should correct the
problem by "overwriting" as you have discovered in your last
sentence..ed