On Thu, 2006-01-19 at 15:15 +0700, Fajar Priyanto wrote: > 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?
You need to create a new default template. This is covered in the manuals at http://documentation.openoffice.org/ The printed 1.1.x manual is still valid if you like printed material. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
