Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default show negative figures in brackets

How do I display negative figures in brackets rather than the minus sign
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default show negative figures in brackets


right click one the cell and select format cells,
select number tab, and the number catagory,
select the format you require


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574446

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default show negative figures in brackets

thanks for the help but my version of excel doesn't offer brackets as an
option in the number category, however I went to "Custom" and found the
brackets there.

thanks again and regards.
"davesexcel" wrote:


right click one the cell and select format cells,
select number tab, and the number catagory,
select the format you require


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574446


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default show negative figures in brackets

If negative brackets are not available in the NumberNegative Numbers dialog.

This is a function of your Regional Settings in Windows OS.

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow
and select the ($1.1)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OKApply your way out.


Gord Dibben Excel MVP

On Tue, 22 Aug 2006 18:04:02 -0700, laverda74
wrote:

How do I display negative figures in brackets rather than the minus sign


Gord Dibben MS Excel MVP
Reply
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 i get negative numbers in brackets in Excel maverick accountant New Users to Excel 1 March 10th 06 03:37 PM
negative figures macro tweacle Excel Worksheet Functions 0 January 22nd 06 12:17 PM
I want to show lapsed time as a negative value kllebou Excel Discussion (Misc queries) 2 October 6th 05 08:12 AM
I cannot get Excel to put negative amounts in brackets. Help ! Frustrated of Great Yarmouth Excel Worksheet Functions 6 July 26th 05 05:11 PM
how do i show figures as words? Carolyn Excel Discussion (Misc queries) 1 June 1st 05 11:17 AM


All times are GMT +1. The time now is 08:38 PM.

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

About Us

"It's about Microsoft Excel"