How do I get negative numbers to display with brackets around it..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I updated to Windows XP, this display option was no longer available
under the Format options. How do I get it back?
 
You really did upgrade (pre Excel 95). Excel does not support negative times.

If it is a matter of getting a difference in time through midnight
=C2 - B2 + (B2 > C2)
the (B2>C2) is a logical expression returns 0 or 1
since time is a fraction of a day the 1 would be adding 24 hours.

If you want functions that deal with dates before 1900 and that
deal with negative time you would need to use VBA, and John Walkenbach
has a formulas for that Extended Date and Time Functions
http://www.j-walk.com/ss/excel (use the search)
 
There's a windows setting you can change:

The way I'd get to in Win98 is:

Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format
 
You must log in or register to reply here.

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

Displaying negatives with (brackets) 3
Negative Number Display -- need Brackets 7
How to show brackets around a negative number 2
negative numbers as brackets an Excel option 2
Option to put brackets around negative numbers not available in 20 3
Negative Numbers in Brackets 2
Excel Excel 2010-how to display negative % with brackets 0
Excel negative number format options don't include brackets. Why? 1

Back
Top