Hello all,



I was wondering what the best way to round standard deviations in excel would be? I have a series of columns as follows:
"2.4567(1)"
"3.2345(12)"
"3.2435(5)

and I would need the macro to "round" 3.2345(12) into 3.234(1) to fit with the rest. The list always has a random order and quantity of values needing rounding, so I would have to allow it to recognize ...(xy) versus ...(z).

Thanks for your advice! ~Bryan~

PS - Due to the brackets, these are initially considered strings in their columns.