Is it possible to show leading zeros for "number" cells?

G

Guest

I am working in Excel and would like to show leading zeros in cells that have
been formated as number cells. Is this possible and how is it done?
 
B

Bob Phillips

Format with the number of digits

For instance

Format>Cells>Custom and input 000000
 

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

How to stop Excel from automatically truncating leading zeros 2
Eliminate leading numbers - Excel 2007 2
How do I stop Excel from dropping leading zeros? 9
Add Leading Zeros 4
How do I keep leading zeros and format my cells as text? 1
Leading Zeros 3
Need 7 digit number with differnt number of leading zeros 10
Array formula to Identify Leading Zeros. 2

Top