On Wednesday 18 January 2006 04:03 am, Jonathon Coombes wrote: > On Tue, 2006-01-17 at 13:30 +0700, Fajar Priyanto wrote: > > On Tuesday 17 January 2006 10:17 am, Jonathon Coombes wrote: > > > [$$-C09]#,##0;[RED]([$$-C09]#,##0) > > Thank you very much Jonathon, > > It works, and also now I know why the syntax is positive;negative;null > > Hi Fajar, > Glad I could help, although the syntax is actually positive,negative, > and zero, not null.
Hi Jonathon, I notice that the format only applies on the current sheet and not for the next newly created sheet. Can I make this format included in Calc's default? Also, I notice from an excel file, the format is a little different: #,##0_);[RED]\(#,##\) Is it ok? -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 15:15:27 up 7:12, 2.6.14-1.1653_FC4 GNU/Linux Let's use OpenOffice. http://www.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
