want to display number when = zero

[Mary]

Hello, I am creating a report but find problem in number display when the
value = 0.

When I've amended the format as "#,##0.00", it was automatically changed to
"Standard" and displayed blank on report preview.

Kindly please advise what should I do in order to display as 0.00 or 0
instead. Many thanks.

 

[Ken Snell \(MVP\)]

Try this:

#,##0.00;-#,##0.00;0;;

 

[Mary]

hello Ken, thanks for your advice. But it can't work.

 

[Duane Hookom]

Try
#,##0.00;-#,##0.00;0.00;0.00;

 

[Marshall Barton]

#,##0.00;-#,##0.00;"0.00"

But it can't work.

"Ken Snell (MVP)"

 

[Mary]

thanks, will try.

#,##0.00;-#,##0.00;"0.00"

 

[Mary]

thanks, will try.

Try
#,##0.00;-#,##0.00;0.00;0.00;