need help cancatenating numerical values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to combine values from many cells into one, but the values have
zero places that get lost after combining them. For example, I need to
combine "00"&"00"&"01" so that the new value reads 000001. But when I do this
with the concatenate function, I lose the 1st zero in every cell so that it
reads 001.
Can anyone help?
Thanks!
-Kier
 
Hi

I'm guessing that the cells contain only 0 but are formatted to display 00.
Try something like this:
=TEXT(C6,"00")&TEXT(C7,"00")&TEXT(C8,"00")

Andy.
 

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

Concatenate Numers / Text (Special) 2
Excel Need Countifs Formula Help 0
concatenate & custom formats 1
help in formula countif OR sumproduct 4
Need help (Average excluding zero values) 2
Insert row(s) with vba 3
Cobining various numbers of cells without using the & or concatena 2
Formatted cells in a formula? 2

Back
Top