making a minus number appear in brackets

W

walianboy

If I have a minus value in excel then normally it appears with a '-
before the number... fine.

However, many accountants want to remover the '-' and replace wit
brackets '(x)' around the number. This makes it easier to spot th
number, especially if the numbers they are dealing with are large.

I'm sure it is quite easy to do this on a single cell, but can it b
done for an entire worksheet, like a rule...?

like, if x = -x, then (x) or something like that?

Please help

cheers

Richar
 
A

Andy B

Hi

Have a look at custom cell formats. There are quite a few options on the
Number tab - and the Accounting tab.
 
W

walianboy

yes, but I'm afriad that the custom option does not offer thi
'bracketed' solution.

Any other ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Numbers in Brackets 2
Formatting cells for phone numbers 1
Is there an easy way to do IEEE style reference 4
Reference every 4th row from a master list of modifiable length 1
adding numbers macro 8
Addiing a Zero to a number which is already there 1
Counting the number of times a word appears 'anywhere' on a page 1
Trying to reduce number of fields 0

Top