Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you

Try using conditional formatting by setting the font color to the background
color?

--
Cheers
Nigel



"John" wrote in message
...
Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you

Do you mean show it as as empty, or blank when it's zero?

You can use a custom number format (Format Cells|Number|Custom) and
enter the following:

0.00;-0.00;

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John wrote:
Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you

Not a reply, but another question.

How would I format a cell to be blank. Say I have a formula such as

=IF(OR(B27="",B25=""),"",B25/B27)

Which would give a percentage of one evalue to another.

If I graph these values, the graph displays it as zero value instead of null
or an empty set. I do not want to convey that they had 0% for the result.

Thanks


"Ken Puls" wrote in message
...
Do you mean show it as as empty, or blank when it's zero?

You can use a custom number format (Format Cells|Number|Custom) and enter
the following:

0.00;-0.00;

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John wrote:
Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you

=IF(OR(B27="",B25=""),NA(),B25/B27)

Cells with #N/A with not be charted.

If you don't like the #N/A showing use Conditional Formating to change the font
to white.


Gord Dibben MS Excel MVP

On Tue, 02 Jan 2007 21:53:57 GMT, "taju" wrote:

Not a reply, but another question.

How would I format a cell to be blank. Say I have a formula such as

=IF(OR(B27="",B25=""),"",B25/B27)

Which would give a percentage of one evalue to another.

If I graph these values, the graph displays it as zero value instead of null
or an empty set. I do not want to convey that they had 0% for the result.

Thanks


"Ken Puls" wrote in message
...
Do you mean show it as as empty, or blank when it's zero?

You can use a custom number format (Format Cells|Number|Custom) and enter
the following:

0.00;-0.00;

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John wrote:
Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you

Thank you for your help. It works very well.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=IF(OR(B27="",B25=""),NA(),B25/B27)

Cells with #N/A with not be charted.

If you don't like the #N/A showing use Conditional Formating to change the
font
to white.


Gord Dibben MS Excel MVP

On Tue, 02 Jan 2007 21:53:57 GMT, "taju" wrote:

Not a reply, but another question.

How would I format a cell to be blank. Say I have a formula such as

=IF(OR(B27="",B25=""),"",B25/B27)

Which would give a percentage of one evalue to another.

If I graph these values, the graph displays it as zero value instead of
null
or an empty set. I do not want to convey that they had 0% for the result.

Thanks


"Ken Puls" wrote in message
...
Do you mean show it as as empty, or blank when it's zero?

You can use a custom number format (Format Cells|Number|Custom) and
enter
the following:

0.00;-0.00;

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John wrote:
Dear all,

How can I format a cell when the cell value is zero,display it as
space

Thanks you

Thank you for your help. It works well.

taju


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=IF(OR(B27="",B25=""),NA(),B25/B27)

Cells with #N/A with not be charted.

If you don't like the #N/A showing use Conditional Formating to change the
font
to white.


Gord Dibben MS Excel MVP

On Tue, 02 Jan 2007 21:53:57 GMT, "taju" wrote:

Not a reply, but another question.

How would I format a cell to be blank. Say I have a formula such as

=IF(OR(B27="",B25=""),"",B25/B27)

Which would give a percentage of one evalue to another.

If I graph these values, the graph displays it as zero value instead of
null
or an empty set. I do not want to convey that they had 0% for the result.

Thanks


"Ken Puls" wrote in message
...
Do you mean show it as as empty, or blank when it's zero?

You can use a custom number format (Format Cells|Number|Custom) and
enter
the following:

0.00;-0.00;

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John wrote:
Dear all,

How can I format a cell when the cell value is zero,display it as
space

Thanks you