The cells were formatted as text. The Edit > Clear All reset the format to whatever format was set for style Normal, which would generally be General. Setting the cell style to Normal would have achieved the same result.