macro to convert negative values with Brackets

[howard]

I have values and percentages in Col D:J on sheets 16 to 25

I would like a macro to convert the negative numbers only eg -125, -128,965 etc in these columns and on these sheets with a bracket eg (125), (125,965) etc


Your assistance in this regard is most appreciated

 

[Twollaston]

I have values and percentages in Col D:J on sheets 16 to 25

I would like a macro to convert the negative numbers only eg -125, -128,965 etc in these columns and on these sheets with a bracket eg (125), (125,965) etc


Your assistance in this regard is most appreciated

Use absolute value function, it will make everything positive number

="("&ABS(D1)&")"

 

[howard]

Thanks for your input