reporting value from other sheet

[TiredOfVista]

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

 

[Bernard Liengme]

=IF(ISBLANK(Sheet1!E10),"",Sheet1!E10)
best wishes

 

[Shane Devenshire]

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.