Adding 0 in front of number to complete 4 digits series

[tantcu]

Hi,

I have a list of numbers with 2, 3, and 4 digits. Is there a formula that can recognize if there are only 2 digits, it will add 2 zeros in front of the number.

For example,

47 will become 0047
234 will become 0234
1234 will become 1234

[elcarp]

Something like:

if(len(cell reference)=4,(cell reference),if(len(cell reference)=3,"0"&(cell reference),if(len(cell reference)=2,"00&(cell reference)))))

cell reference = cell with data

May work

[ChemistB]

you can do Format Cell> Custom> 0000
which changes the appearance but not the reality (234 is still number 234)
or in another cell
=TEXT(A1, "0000"). this changes the value to text with the appropriate zeros.

[XOR LX]

Hi,

=TEXT(A1,"0000")

Regards

[tantcu]

Thanks guys! All the tips are very useful!!