CONCATENATE with a "0" in front.

[serge]

Hi,
I'm wondering if my CONCATENATE formula could be modified to return a number of 8 digits each time, it need when it is a single digit to return it with a "0" in front.
Thank you.

 

[Peter_SSs]

return a number of 8 digits each time, it need when it is a single digit to return it with a "0" in front.

I need it as a Number

Does that mean that column B will never be a single digit?

 

[serge]

Does that mean that column B will never be a single digit?

Hi Peter,
You are right the B column will always be 2 digits.

 

[serge]

Thank you Rick for looking at it too, I appreciate it, I'm sorry I'm still on Excel 07 it works fine for me I don't need more or what I do.

 

[serge]

You could also write that like this...

=SUM(B3:E3*10^{6,4,2,0})

=SUM and =SUMPRODUCT both works fine with my 07 thank you Rick.

 

[Rick Rothstein]

=SUM and =SUMPRODUCT both works fine with my 07 thank you Rick.

Just verifying... SUM works by just using ENTER by itself to commit the formula?

 

[serge]

No, I have to CTRL+SHIFT+ENTER

 

[Peter_SSs]

Hi Peter,
You are right the B column will always be 2 digits.

Thanks for confirming.