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.
 
You must log in or register to reply here.

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

Concantenate which keeps bold of some parts. 5
Show other cell if blank 5
Function to format a value into percent with no decimal 3
Nested IF conditions 3
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Cell colour change if formula displays false 3
VLOOKUP formula? 12
Countif function giving incorrect answer 5

Back
Top