Fajar Priyanto <fajarpri <at> cbn.net.id> writes: > > Hi all, > We're using OOo 2.0.1. > One of the users asked whether we can use bracket instead of minus sign for > negative value in Calc. > > Ex: > Intead of -5000, she wants it: (5000) > > How do we format the cell? > Thank you.
/Cells /Format : Number Tab >Category Number. Choose the format code that best suits (subject to changing the negative symbol), remove the minus sign and substitute brackets. You then click on the tick and the format becomes a user-defined one. E.g, change "General;-General" to "General;(General)". --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
