My workbook has some range names (one cell only) for some alphabetic character names. On one worksheet, if I refer to that range name (such as =rangename1), the contents of that cell shows as empty (on the monitor, not sure about if I printed it) if the range name cell is empty. On another worksheet, it shows as zero, which I don't want, especially since it's not a number.

They both seem to have the exact same format, which is "General". I even used the format painter from the former to the latter to be safe, but the latter still shows as zero.

I can think of some workarounds, such as an IF statement but it all seems so unnecessary. Does anyone know why this is happening?

Thanks!
Dean

Have you checked the ToolsOptions... View tab? There's a checkbox there
that allows or doesn't allow you to see zero values.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=563803

That's it - thank you. I never noticed that feature. I had inherited
worksheets with lots of blanks, which always bothered me since I start
thinking someone deleted the cell contents inadvertently.

For what it's worth, I guess you can override that blank format if you
format the cells using accounting format, in which case you'll see the dash,
which means its zero, despite the overall worksheet setting you just told me
about.

Thanks again!
Dean

"kev_06" wrote in
message ...

Have you checked the ToolsOptions... View tab? There's a checkbox there
that allows or doesn't allow you to see zero values.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile:
http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=563803