Solved

remove brackets from negative numbers

Posted on 2016-08-10
9
98 Views
Last Modified: 2016-08-10
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
0
Comment
Question by:racepro
  • 4
  • 3
  • 2
9 Comments
 
LVL 5

Accepted Solution

by:
Manuel Flores earned 350 total points
ID: 41751084
Apply some Custom format to cells, like;

0,00_ ;-0,00

Right button on cell -> Format Cell -> Number -> Custom
0
 

Author Comment

by:racepro
ID: 41751088
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
 
LVL 14

Assisted Solution

by:Schnell Solutions
Schnell Solutions earned 150 total points
ID: 41751089
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 14

Expert Comment

by:Schnell Solutions
ID: 41751090
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
 

Author Comment

by:racepro
ID: 41751095
Thanks guys, the clicking of warning icon helped
Ian
0
 
LVL 5

Expert Comment

by:Manuel Flores
ID: 41751098
;)

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
 
LVL 5

Expert Comment

by:Manuel Flores
ID: 41751101
As far as I can see in my excel version, it is formatted as number.  The Custom format should work.

..MFlores..
0
 

Author Comment

by:racepro
ID: 41751105
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
 
LVL 5

Expert Comment

by:Manuel Flores
ID: 41751110
yeap!... they do all the magic.  Thank you!.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question