Hello Richard,

Copying the contents of a cell, also copies its formatting. Typing in the formula preserves the existing formatting.

My guess is that the row has "zero suppress" turned off.