Well, I have 1888 cells with data in 5 sheets, so a LOT of cells. The results are anywhere from 0.0000008 - 300, and depending on the result I only want a specific amount of decimals, like zero for numbers above 1 and 1 decimal for numbers between 0.1 and 1, etc... so that's why I used conditional formatting, so that every single cell, depeding on it's value would get a different amount of decimals. So with this formatting, your formula wouldn't really work on a drag basis, as I would have to change the digit selector for every single cell. But I have found the answer in the meantime, which is removing all conditional formatting from the sheet and using a text function with a conditional formatting built in, so this now looks like
=TEXT(G29,IF(G29>10,ROUND(G29,0),IF(G29>1,ROUND(G29,1),IF(G29>0.1,ROUND(G29,1),IF(G29>0.01,ROUND(G29,2),IF(G29>0.001,ROUND(G29,3),IF(G29>0.0001,ROUND(G29,4),IF(G29>0.00001,ROUND(G29,5),ROUND(G29,6)))))))))&" - "&TEXT(H28,IF(H28>10,ROUND(H28,0),IF(H28>1,ROUND(H28,1),IF(H28>0.1,ROUND(H28,1),IF(H28>0.01,ROUND(H28,2),IF(H28>0.001,ROUND(H28,3),IF(H28>0.0001,ROUND(H28,4),IF(H28>0.00001,ROUND(H28,5),ROUND(H28,6)))))))))
Bit of a monster formula but given the amount of data I'm working on, it's the business!