How to convert (calculated) zero to blank cell in column

**canada123** · 11-16-2011, 02:30 PM

I am not good in excel.

Can some one please help me to convert (calculated) zero to blank cell in a column? The calculated means zero is not typed in but is calculated from other cells by using formula.

Due to this calculated zero, most of the replies from all experts does not seem to be working. It was my fault as i did not make it clear in the beginning.

I have attached the sample spreadsheet.

Appreciate your help.

thanks.

Note to experts - Please try to reply again. Thank you.

**NBVC** · 11-16-2011, 02:39 PM

Format all the cells as Number:Custom with Type: 0;-0;;@

**GeneralDisarray** · 11-16-2011, 02:40 PM

no longer applies

**Philb1** · 11-16-2011, 02:42 PM

Or

Please Login or Register  to view this content.

in your output column dragged down

**Marcol** · 11-16-2011, 02:50 PM

You could try Custom Formatting

Select your range C5:C13 Then Format > Format cells ... Then with the "Number" Tab > Custom
Type:=

Please Login or Register  to view this content.

This will return the integer part of the number only, and a blank if the value is 0 (zero)
If you need decimal numbers then, this will return one decimal

Please Login or Register  to view this content.

And so this will return two decimal figures, etc ...

Please Login or Register  to view this content.

This way the underlying figure will remain unchanged for further calculations.

Another option is in Excel Options > Advanced > "Display options for this sheet"
Uncheck "Show zero in cells that have zero value"