zero values

  • Thread starter Thread starter PeCoNe
  • Start date Start date
P

PeCoNe

Zero values are shown as blank.
In this cell only i want to see 0.00%
how can i do that?
 
Hi Peter,

Am Thu, 09 Jan 2014 16:16:22 +0100 schrieb PeCoNe:
Zero values are shown as blank.
In this cell only i want to see 0.00%
how can i do that?
Click to expand...

why are zero values shown as blank. Because of a formula? Then you have
to change the formula for this one cell.


Regards
Claus B.
 
Zero values are shown as blank.
In this cell only i want to see 0.00%
how can i do that?
Click to expand...

Hi PeCoNe,

Using my English version of Excel:

Click the Office Button | Excel Options | Advanced |
Display options for this worksheet |
Select: Show a zero in cells that have zero value |
OK


===
Regards,
Norman
 
Claus Busch schreef op 2014-01-09 16:52:
Hi Peter,

Am Thu, 09 Jan 2014 16:16:22 +0100 schrieb PeCoNe:


why are zero values shown as blank. Because of a formula? Then you have
to change the formula for this one cell.


Regards
Claus B.
Click to expand...
Hi Claus,

All zero cells are shown as blank.
That is like i want.
Only in this cell i need 0.00% shown.

Bye Peter
 
Hi Peter,

Am Thu, 09 Jan 2014 17:18:13 +0100 schrieb PeCoNe:
All zero cells are shown as blank.
That is like i want.
Only in this cell i need 0.00% shown.
Click to expand...

if your values are % then format your cells custom:
0.00%;-0.00%;
Only in this one cell delete the last semicolon


Regards
Claus B.
 
Hi Peter,

I send you 3 mails. But I got error messages that your address is
invalid.


Regards
Claus B.
 
Back
Top