Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tom
 
Posts: n/a
Default Working with minus figures

how do i get a minus figure in brackets with out having the (-) symbol.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way custom format

General;(General)

or

0.00_);(0.00)

--
Regards,

Peo Sjoblom

(No private emails please)


"Tom" wrote in message
...
how do i get a minus figure in brackets with out having the (-) symbol.


  #3   Report Post  
olasa
 
Posts: n/a
Default


Right click on the cell. Format cells... Select Category: Custom and
write in Type: 0;(0)
HTH
Ola
http://support.microsoft.com/?scid=k...d=1743&sid=340


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=384579

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
Show minus figures with brackets Louise Excel Discussion (Misc queries) 7 June 24th 05 01:18 PM
calculate minus figures Nigel Excel Discussion (Misc queries) 1 March 30th 05 04:33 PM
calculate minus figures only Nigel Excel Discussion (Misc queries) 2 March 30th 05 12:03 PM
Calculate minus figures only Nigel Excel Discussion (Misc queries) 0 March 30th 05 10:31 AM
I want to get brackets round my figures not minus signs Peru Excel Discussion (Misc queries) 3 February 3rd 05 09:30 PM


All times are GMT +1. The time now is 03:40 AM.

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"