Hi,

You can leave your formula alone and format the cell to

General;General;;@

or if you only want results back if there is text in the other cell use the
format

;;;@

Choose Format, Cells, Number tab, Custom, and enter the above on the Type
line.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TiredOfVista" wrote:

I realize this is a rudimentary question but I can't figure out how to do it.

I am trying to report a text value from one sheet to another. On sheet B I
type "=" in the cell then jump to sheet A and select the cell I want. Sheet B
in that cell shows: =Sheet1!E10

When I hit return the cell on sheet B shows "0"

I thought assigning the cell on both sheets to 'Text' would fix it. It does
not. What am I missing.

P