Dear All,
Hopefully something has an idea...
I have an excel spreadsheet with conditional formatting, as I have values ranging from 0.0000012 to 800 and I've put on conditional formatting on the number of decimals.
Now I want to combine values from two columsn in one by using something like
= A1 & " - " & B1 so that I get something like 0.008 - 6.7
the problem is that I am loosing my conditional formatting in this process and what I'm getting is
0.0089632541 - 6.742369871
I know I can use the round function, but since every cell has a different amount of decimals I would get very very old in the process. So I'm wondering is there anything that I can put into the above formula that will make it retain the original number formatting?
Would be ever so grateful if someone had a solution....
Hopefully something has an idea...
I have an excel spreadsheet with conditional formatting, as I have values ranging from 0.0000012 to 800 and I've put on conditional formatting on the number of decimals.
Now I want to combine values from two columsn in one by using something like
= A1 & " - " & B1 so that I get something like 0.008 - 6.7
the problem is that I am loosing my conditional formatting in this process and what I'm getting is
0.0089632541 - 6.742369871
I know I can use the round function, but since every cell has a different amount of decimals I would get very very old in the process. So I'm wondering is there anything that I can put into the above formula that will make it retain the original number formatting?
Would be ever so grateful if someone had a solution....