On Tue, 2006-01-17 at 10:11 +0700, Fajar Priyanto wrote: > 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?
I think there is some builtin formats for this, but otherwise you can do it with a format string such as: [$$-C09]#,##0;[RED]([$$-C09]#,##0) This will give you the (5000) in Red with dollar sign. If you do not want the dollar sign, drop them out of the above. Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
