Maintain display leading zero(s)

[biminy]

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)

 

[shades]

In the Format Cell dialog box, instead of General, choose Custom (at the bottom), then type in what you want as the pattern (000).

 

[Tommy Bak]

Hi
1. Format the cells as text. If it has leading zero, this will keep the leading zero.

2. I don't think it's possible to regenerate your leading zero's when you cannot undo anymore.

regards Tommy

 

[lbass]

If all your numbers have the same number of digits you can test for the length then add the number of 0's needed. Otherwise unless you have a backup file with the leading 0's still showing I'm afraid you will have to do it manually.
The only way I have found to keep the leading 0's is to format cells number text.
Then if you need to do any math use =Value()
I'm new to this so maybe someone else will be able to help you more.
l