remove brackets from negative numbers

Can someone please assist with the format to remove brackets from negative numbers and display in a minus format
change from (3.00) to -3.00
see attached
Many thanks
Ian
Remove-brackets-negaitive-numbers.xlsx
raceproretiredAsked:
Who is Participating?
 
Manuel FloresConnect With a Mentor Commented:
Apply some Custom format to cells, like;

0,00_ ;-0,00

Right button on cell -> Format Cell -> Number -> Custom
0
 
raceproretiredAuthor Commented:
Didn't work Manuel,
Is it number or custom ?, it can only be one or the other
can you please change on spreadsheet I attached
Thanks
Ian
0
 
Schnell SolutionsConnect With a Mentor Systems Infrastructure EngineerCommented:
Yeah. Exactly like 'el amigo Manuel Flores' specified.

I also noticed that the cells in the file appear with a non-number format, remember to convert them to numbers as well clicking on the warning icon next to the cell (or array of cells for making all of them together).
1
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Schnell SolutionsSystems Infrastructure EngineerCommented:
Format Cell -> Number -> Number (is easier). And then choose the format that you want.

But it is the same, it is just that Manuel specified in a custom mode, where you have a higher degree of customization.
1
 
raceproretiredAuthor Commented:
Thanks guys, the clicking of warning icon helped
Ian
0
 
Manuel FloresCommented:
;)

Convert to numbers, and specify a custom format with 0,00_ ;-0,00
I suppose that the original was a number an after that it was formatted with parenthesis format... if later was copied and pasted with parenthesis is likely that now the format is text.  You must, probably remove the brackets before apply the number format or custom format in your case.

You could remove the brackets using a kind of IF and LEFT and RIGHT formulas.  Let me know if you need help with this.

..MFlores..
0
 
Manuel FloresCommented:
As far as I can see in my excel version, it is formatted as number.  The Custom format should work.

..MFlores..
0
 
raceproretiredAuthor Commented:
All I need to do is highlight the range format as number and click on error ! icon and select convert to number and wala :)  Thanks Manuel
0
 
Manuel FloresCommented:
yeap!... they do all the magic.  Thank you!.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.