ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Working with minus figures (https://www.excelbanter.com/excel-discussion-misc-queries/33816-working-minus-figures.html)

Tom

Working with minus figures
 
how do i get a minus figure in brackets with out having the (-) symbol.

Peo Sjoblom

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.



olasa


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



All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com