Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

how remove brackets parentheses

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to remove brackets (parentheses) from a cell?

How to remove brackets (parentheses) from a cell?

ResolvedVersion 2010

Maria has attended:
Excel Advanced course

How to remove brackets (parentheses) from a cell?

Hi,

Please can you tell me how I can remove the brackets from a cell that has a formula in it?

Find/Replace doesn't work because of the formula in the cell.

Neither does adding *1 at the end of the equation.

How do I get around showing my debits and credits in just numbers with no +/-?

Thanks,

Maria

RE: How to remove brackets (parentheses) from a cell?

Hi Maria

Thank you for your question. You have a couple of options. You can enclose the formula with an ABS() function. This will strip the positive and negative from the number, just leaving the value.
Alternatively it sounds like the brackets are appearing around your negative values because a number format has been applied.
Highlight your cells, right click and choose format cells. In the Number tab choose the custom format.

Search down the list of formats until you find

#,##0;[Red]-#,##0

the semi colon divides the formats for positive numbers and negative numbers

select this format and in the Type box edit the negative half of the format by removing

[Red]- 

in other words the format will be the same for both positive and negative formats.

so you can either return a value that is always positive using abs() or retain the true value but make it appear without brackets using a custom number format.

Hope this helps - let me know if you need any further help.

Kind regards,
Andrew

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help


3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.