Loosing Zero's in front of number

R

randy beach

I am trying to make a list of numbers that Has only 6 digits (000006
and not loose the zero's when I hit enter. Is there a way to limit th
number of digits in the number set and when I enter 78 or somethin
similar so it would drop the 0 of the left side to maintain the 6 digi
length
 
D

David Prout

Format the cell(s) using Format/Cells. Take the number tab and then choose Custom Format, usually
at the bottom of the list. Type 000000 in the custom format box. then click OK. Numbers should now
appear with 6 digits in the formatted cells

DavidP
 
G

Guest

Hi Randy
Select the cells you want to format -Custom Category - In the "Type" box you can type 000000 & hit ok
Regards
Pinky Variava
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating zero's in front of number and after number 3
Adding zero's to the beginning of a number 5
How do I stop Excel from dropping leading zeros? 9
Zero Placeholders in number cell 3
Add missing zero's to customer number 3
Need 7 digit number with differnt number of leading zeros 10
Count last nonzero number in a column 1
need a formula to find "*" in s string and multiply by preceding andfollowing values 5

Top