Cell Values

[Rich]

I know this might sound simple but I can't get it to work!!
I have quite a few simple formula's setup that just Sum
about 4-5 rows at a time. Some of these values however
are '0' and often the Sum is also '0'. The trouble I am
having is that the '0' values are not showing when the
cell format is set to Number. They show when I set the
Format to Text but then the formula doesn't work.
For example -
a b c
1 0
2 0
3 0
4
5 =SUM(B1:B3)

The formula should equal '0' but when text appears as the
formula but when number the cell appears blank.

I need all '0' values to be shown and all cells set to
Number format.

Any help!!

 

[papou]

Hi Rich
Tools, Options, View tab and tick "View zero values"

HTH
Cordially
Pascal

 

[Brandon]

Try going to "Tools" - "Options" and click on the "view"
tab. There should be a check box where you can select to
view zero values. Play around with it and you should be
able to fix everything you are talking about here.

Brandon