MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I convert minus figures to braket figures?


Posted by Elwish on May 31, 2001 2:28 AM

I have figures in negative, I normally convert using Lotus commands, could you tell me how do I do the same in excel, I want this to be my default setting. Please Help.
Thanks.


Posted by Dominic on May 31, 2001 2:44 AM

In Excel Goto your Menu bar
Click on Format
Click on Cell
Scroll down to UserDefined( could have a slightly different description-- my machine is German)
In the small field enter the following
#.##0,00;(#.##0,00)

you can change the commas and periods around to suit your formatting.

Then press OK

Then use this new Format to reformat the required Cell

If you want the figures also to be in red then add this [RED] in front of the bracketed figures in the format setup function.

You might also find that your machine already has this format

Posted by Eric on May 31, 2001 10:01 AM

"=abs()" command

If you mean converting negative integers into their absolute values, then use
=abs()
if your data is in column (A) starting in row 2, then copy and paste the formula
=abs(a2)
from b2 to the end of your data set.

Hope that helps