number format

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I want to be able to format a number so that
if it is 0 it shows "-"
If it is positive is shows 2 decimal places like 10,500.30
If it is negative it shows in brackets like (10,500.30)

How can I do this

Thanks

A
 
Custom format of

#,###,##0.00;(#,###,##0.00);"-"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top