S
Shane
How do you format a cell so that when enter a number and
enter the rest of the cell will have leading zeros?
enter the rest of the cell will have leading zeros?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
right click on cell>format>custom
0000# will make sure you have 5 numbers. Add/sub 0's to suit.
0000# will make sure you have 5 numbers. Add/sub 0's to suit.
K
kpo
leading zeros ie '000010. It will show the zeros but not-----Original Message-----
How do you format a cell so that when enter a number and
enter the rest of the cell will have leading zeros?
.
I have successfully used an apostrophe ahead of the
the apostrophe.
L
luv2waterski
Thanks KPO, that's an answer that I could use.
-Darren
-Darren
D
Don Guillett
But then you must enter the apostophe and each leading 0.
Easier to enter 1 and get 00001 if you wanted 5 digits.
Easier to enter 1 and get 00001 if you wanted 5 digits.
L
luv2waterski
my concern wasn't the same as the original author. I was entering
product ID#s and they vary in length, and some start with a zero. So,
for my instance, an ' is the best for me. I only have to type in the
' if I have a leading zero.
-Darren
product ID#s and they vary in length, and some start with a zero. So,
for my instance, an ' is the best for me. I only have to type in the
' if I have a leading zero.
-Darren