I guess what I'm getting at is if you're wanting all of the values
displayed as,
say 2 place  decimals, you can use something like:

Cells(i, 5) = "'(" & Format(Cells(i, 1), "##,##0.00") & ")"

the result will be a text string.
If you're wanting the value to be forced to round down (or up, or truncate)
you'll have to do that to the cells(i,1) within the formula.

does this help?