Hi ,
my question ...I have 2 numbers in 2 different cells...one is a negative number.When I use the concatenate formula the result is as follows
cell a1 = 7 cell b1 = -9
=concatenate(a1," - ",b1) the result in the cell looks like 7 - -9
can I write a concatenate formula to put the negative number with parenthesis...so it would look like this 7 - (9) all in one cell ?
Thanks everybody
my question ...I have 2 numbers in 2 different cells...one is a negative number.When I use the concatenate formula the result is as follows
cell a1 = 7 cell b1 = -9
=concatenate(a1," - ",b1) the result in the cell looks like 7 - -9
can I write a concatenate formula to put the negative number with parenthesis...so it would look like this 7 - (9) all in one cell ?
Thanks everybody