LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Negative Numbers in Brackets

Could someone please advise me how I set up a custom number format that makes
negative values appear in brackets eg minus 56000 like this (56,000) rather
than -56000. I still want the comma, dollar options on the toolbar to
function as they currently do such that if I select $ icon, this number will
turn into $56,000.00 or if I want to use the increase/decrease decimal point
for say 2 decimal places that my result is (56,000.00) or if I use the comma
icon that it defaults to 2 decimal places all with brackets for negative
numbers.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you put negative/minus numbers in brackets IoHeFy Excel Discussion (Misc queries) 2 October 25th 06 12:12 PM
Negative numbers in brackets Keith Excel Discussion (Misc queries) 4 September 25th 06 12:34 PM
how do i get negative numbers in brackets in Excel maverick accountant New Users to Excel 1 March 10th 06 02:37 PM
How do I get brackets around negative numbers? Gordon Excel Discussion (Misc queries) 9 February 27th 05 11:53 PM
Negative Numbers in Brackets - HELP! Hélène Excel Discussion (Misc queries) 21 February 18th 05 10:08 PM


All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"