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.
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.