Formatting in Formula

  • Thread starter Thread starter Dragon
  • Start date Start date
D

Dragon

Hi, I am trying to concatenate a few columns but having trouble with number
format

Column A: ABCDEF
Column B: 015 (this col is formatted with 'Number 000')
Column C: XYZ

Formula A1&B1&C1

I am getting ABCDEF15XYZ
I need ABCDEF015XYZ

Any ideas how would I go about formatting the number in the formula so it
shows leading zero?

Thank you.
 
The only way i can think is to format the cell with 015 AS TEXT the
retype it in, this will work for your cocantenate but will stop yo
adding up the number if u need to do tha
 
actually something that is better

=concatenate(a1,0,b1,c1)

just put a zero in between two commas before the number cell

that way you can add the numbers as wel
 
Thank you Scott.

Col B was incrementing and adding 0 manually wouldn't work after it reaches
100 and made it 4 digits.

Thank you though.
 
Back
Top