Leading zeroes formula

S

Steve

Hi everyone. In column B I have a list of numbers. Each number
varies in length, but no number is longer than 6 cbaracters. I need a
formula that will make each number rxactly 6 characters by attaching
leading zeroes to the FRONT if the number is less than 6 characters,
or do nothing if the number is already 6 characters. The "number" can
be converted to text.

Thanks!
 
M

Mike H

Hi,

Select the cell(s) and then

Format|cells - Custom

enter a custom format of 000000 That's 6 zeroes.

Mike
 
J

Jarek Kujawa

of course I meant

=IF(LEN(B1)<6,REPT("0",6-LEN(B1))&B1,IF(LEN(B1)=6,B1,""))

HIH
 

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

Strip leading zeros 5
Cocatenate not showing leading zeros MS Excel 2003 6
Concatenation with leading zeros 6
Insert Varying Leading Zeros 2
leading zeroes 2
Concatenate drops leading zeroes 2
single quote 10-digit number that has leading zeroes & then conca. 1
Using ToString to pad an integer with leading zeroes 8

Top