reporting value from other sheet

  • Thread starter Thread starter TiredOfVista
  • Start date Start date
T

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
 
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.
 
Back
Top