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