Maintain display leading zero(s)

biminy

New Member
Joined
Feb 22, 2002
Messages
31
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)
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
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

Active Member
Joined
Feb 25, 2002
Messages
288
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

Board Regular
Joined
Aug 15, 2002
Messages
104
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
 

Forum statistics

Threads
1,147,677
Messages
5,742,566
Members
423,738
Latest member
AshleyKitsune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top