MS Excel Query
Join Date: Dec 2002
Location: wirral
Posts: 66
Likes: 0
Received 0 Likes
on
0 Posts
Yes.
Assuming you only want the cell to show a number when it is not zero highlight the cell click on format then conditional formatting.
enter in the boxes cell value is equal to 0
then click on format select white as the colour (assuming you are leaving the cell white!) then ok ok
Hope this helps
CK
Assuming you only want the cell to show a number when it is not zero highlight the cell click on format then conditional formatting.
enter in the boxes cell value is equal to 0
then click on format select white as the colour (assuming you are leaving the cell white!) then ok ok
Hope this helps
CK
Join Date: Apr 2002
Location: UK
Posts: 6
Likes: 0
Received 0 Likes
on
0 Posts
Another way is to change the format :
Menu - Format, Cells, Custom, and then type in ;;; (three semi colons)
Formulae and text still exist, but can only be seen in the formulae bar at the top of the screen.
Menu - Format, Cells, Custom, and then type in ;;; (three semi colons)
Formulae and text still exist, but can only be seen in the formulae bar at the top of the screen.