CONCATENATE

S

Skinman

Using excel 2007
If I concatenate excel cells that have a format of two digits
like 117.00 -- 114.36 -- 89.60 It drops the trailing 0 and if the 0 is
after the decimal point it also drops the decimal point
e.g. the above will come out like this 117 -- 114.36 -- 89.6
For alignment sake (readability) I would like to retain both digits
I want to do this for a large number of cells in different columns
so my concatenated cell would show 2 decimal placings
Will I need to write a function to do this?
Cheers.
 
S

Shane Devenshire

Hi,

Here is a slimmed down version:

=TEXT(A1,"#.00 -- ")&TEXT(B1,"#.00 -- ")&TEXT(C1,"#.00")

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

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

Top