Thanks for that Tom - I will try it
James
On 29/04/2010 9:18 AM, TomW wrote:
James:
By removing the 'T" function, changing "&" to a "+', and defining a
currency style, the following would seem to do what you want.
+(IF(A30<0; STYLE("fmtWhite"); STYLE("fmtCurrency")))
TomW
--
James Elliott BSc JP
Private mail account: james.elli...@wn.com.au
Address: PO Box 44, Boddington WA 6390
Phone: +61 8 9883 8178 Fax: +61 8 9883 9519
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org