CONCATENATE
 

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.

CONCATENATE
 

=TEXT(A1,"#.00")&" -- "&TEXT(B1,"#.00")&" -- "&TEXT(C1,"#.00")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Skinman" wrote in message
...
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.

CONCATENATE
 

Thank you very much
Skinman

"Bernard Liengme" wrote in message
...
=TEXT(A1,"#.00")&" -- "&TEXT(B1,"#.00")&" -- "&TEXT(C1,"#.00")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Skinman" wrote in message
...
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.

CONCATENATE
 

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


"Skinman" wrote:

Thank you very much
Skinman

"Bernard Liengme" wrote in message
...
=TEXT(A1,"#.00")&" -- "&TEXT(B1,"#.00")&" -- "&TEXT(C1,"#.00")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Skinman" wrote in message
...
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.