Cell format

  • Thread starter Thread starter Sokoban
  • Start date Start date
S

Sokoban

Want the cell dosen't show anything then the value is zero.
How I do that ??

// Sokoban
 
Hi Sokoban,

If I understand you correctly, just wrap your formula
inside an IF function:

=IF(YOUR_FORMULA=0,"",YOUR_FORMULA)

or

You can goto Tools>Options>View>Zero Values

Biff
 
Thanks it works....with option. I don't understand your calculate with
YOUR and FORMULA. What is this ???

// sokoban
 
You must log in or register to reply here.

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

Similar Threads

Format cell if cell is zero 1
Date for latest Update 1
Numbers turning to Zero's 1
Formatting 0 values to show blank cells 4
default currency format 1
zeros show as dashes in spreadsheet, want to show 0. 2
Displaying zeros in cells 2
Question about conditional formatting of zeros in Excel 0

Back
Top