Formatting a Cell

  • Thread starter Thread starter VickyC
  • Start date Start date
V

VickyC

Hello,

I am trying to create a Bill Template in Excel. I have set it all an
added all the equations I need. I would like the cells to be blank an
not show 0.00 where the cells have equations. Is this possible?

I would appreciate any help.

Many thanks
 
Hello,

I am trying to create a Bill Template in Excel. I have set it all and
added all the equations I need. I would like the cells to be blank and
not show 0.00 where the cells have equations. Is this possible?

I would appreciate any help.

Many thanks,
Click to expand...

Wrap your formula in an IF statement where you first test it for a condition to
not be shown, and output a "" if that is the case. For example:

=IF(Qty="","",Qty*Price)


--ron
 
On the main menu, select Tools>Options. On the View tab, uncheck th
"Show zero values" in the 'Windows options' section.

HTH

Bruc
 
VickyC said:
Is this possible?
Click to expand...
First of all: Yes it is.
Here are my suggestions:
1. You could write a macro that replaces all "0"s by "" (empty string)

Code
-------------------
For Each cell In Range("A1:C3") 'Example for the first 3 cells in col A, B and C
If cell.Value = 0 Then cell.Value = ""
Next cel
-------------------

This way, deleting the zeros, could end up in an error if you want t
calculate wih these cells.
In this case here comes suggestion #2:
In the format/Cells Menu at the Numbers Tab you can choose "use
defined"
Enter
0.00;0.00;""
That should work (if it doesn't, try to replace the periods by commas)

In user defined mode you can Enter four format groups divided b
semicolon
First for positive Numbers; second for negative numbers;third for zero
fourth (hmm, actually forgot what was the fourth group for)

Hope that I could help:),
Simo
 
Another very clean way to do it is go to the custom cell formatting an
type this in:

#;#;


Good luck with that
 
Back
Top