zero values


P

PeCoNe

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

Advertisements

C

Claus Busch

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?

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.
 
N

Norman Jones

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

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
 
P

PeCoNe

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.
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
 
C

Claus Busch

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.

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.
 
Ad

Advertisements

C

Claus Busch

Hi Peter,

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


Regards
Claus B.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top