On 19/01/2006, at 7:15 PM, 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?
Hi Fajar,
To keep any formats for new sheets, you will have to add them to your
default
template. This is explained in the online documentation or in the OOo
knowledgebase at http://mindmeld.cybersite.com.au.
Regards
Jonathon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
