Hi, I am combining multiple cells of data into one cell and also rounding to two decimal points. My formula that I am using is this:
=C1&"/"&ROUND(C2,2)&"0/"&ROUND(C3,2)&"0/"&ROUND(C4,2)&"/"&ROUND(C5,2)
so it will come out like this: 1904/1.10/214.50/1903.97/-1.16
the problem I am running into is anywhere a number has a zero after the decimal point in the original cell example (1.00) it comes out just (1) with no decimals in the merged cell. Is there a way around this at all? if I do it on another cell but only take that data and not combining all the other cells it works fine. And it only does it with numbers that end in zero after the decimal.
Any help would be appreciated
Thanks