I have a column of numeric values - some of which have leading zero(s) that I want to remain visible. The column has cell format set to "general" and all of the values with leading zero are fine and visible. However, when I enter the cell and exit the leading zeros are removed. The Cell format still indicates it is "General". When I try to copy format of different cell (where the leading zero still visible)no luck in getting the problem cell to return to displaying the zero. How do I get it to: not
lose the leading zeros in first place, secondary - how to restore the leading zero (when undo is no longer an option)
lose the leading zeros in first place, secondary - how to restore the leading zero (when undo is no longer an option)