concatenate numbers

Hi all, I would like to concatenate a 10-digit number located in column A, a number located in column F and a number located in column G. The resulting string must be a 26-digit number. The number in column F must be 10 digits in length by adding leading zeroes (if required) and the number in...

Hi there, I wish to concatenate a integer and text in one cell. I wish to convert the integer into a percentage and round it down to 2 decimal places. Here is my current formula: =CONCATENATE(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100)," % and text") However, I am left with a number...

Excel 2007 I'm updating a price sheet to show prices with a gas surcharge amount and the actual amount of the surcharge. I'm using the =concatenate command to put both of these prices in one cell. So my formula looks like: =CONCATENATE(ROUND(Sheet2!B3*(1+$B$3),2)," /...