leading 0 (zero)

  • Thread starter Thread starter Guest
  • Start date Start date
Several ways to go about it but I use text, note this will change the numbers
to text, replace "000" with total number of digits
=Text(A1,"000")
 
If you want a leading zero, so that all numbers have
a fixed size
use Custom Format 00000 or however many digits you want

Steve
 

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

Excel time leading 1st ZERO 3
Open CSV as txt data 5
Leading zero's trail Number 3
Rounding cents 3
arithmetic on minutes and seconds without leading zero 1
How to count the maximum number flanked by zeros 9
Keep Leading Zeros in Concatenation 5
Displaying zeros in cells 2

Back
Top