oops should have said remove the
[red]
if you don't want it in red as well as parenthesis.
--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"JulieD" wrote:

Hi John

click on the cell
choose format / cell
under CUSTOM
type
#,##0.00;[Red](#,##0.00)

this should give you what you want.

--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"John Nollett" wrote:

The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?