You could always suppress zeroes, ToolsOptionsViewZero Values in the
windows Options segment.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tealady" wrote in message
...
I know it's possible to copy absolute values from one page to another but
I'm
trying to copy text and I'm getting '0' in the cells that are blank. How
can
I remedy this? Do I need to format cells? If so, on one sheet or both?