Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make Excel 2003 treat blank cells as zero?
I think there is a toggle to make 2003 calculate blank cells as zero, but
can't find it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make Excel 2003 treat blank cells as zero?
If you have a formula like:
=A1+A2 and either A1 or A2 is empty, the formula treats them like zero. if, however, A1 contains something like: ="" then =A1+A2 will display #VALUE! This is because Excel now treats A1like a string. To fix this use: =N(A1)+A2 -- Gary''s Student - gsnu200859 "Wortman" wrote: I think there is a toggle to make 2003 calculate blank cells as zero, but can't find it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make Excel 2003 treat blank cells as zero?
Under Tools-Options-View, there is an option to treat hide zero values.
Also, when dealing with a PivotTable you have the option of making blank cells display 0. In math operations, using a blank cell the value is calculated as zero. However, there is not an option to make all blank cells display zero. (if you think about it, this would make a giant spreadsheet, making it almost impossible to print what you actually wanted) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Wortman" wrote: I think there is a toggle to make 2003 calculate blank cells as zero, but can't find it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
treat text as blank | Excel Discussion (Misc queries) | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
Force Excel To Treat A Cell As Blank | Excel Worksheet Functions | |||
Lookup formula - treat no-registered cells as blank | Excel Worksheet Functions |