Reference cells from another worksheet problem

Worksheet call MAIN
Worksheet call OTHER

In a cell on the OTHER worksheet I have =MAIN!A1. The value in A1 in the
MAIN worksheet is space, but it appears as 0.0.0000 in the cell on OTHER
which has a format of general. How do I get rid of 0.0.0000.
--
ndd

Hi Neil,

Recheck your formula. I tried what you wrote and it worked for me. You might want to Right click the cell in question and try Number/Text.



Hope this helps

Hi Keith,

Formula is =MAIN!W8

W8 is blank. Whether format is general or text, the value that appears in
the cell on the Other worksheet still appears as 0.0.0000. I then try to
reset the format on the other worksheet cell from general to text and when I
do this it changes the value from 0.0.0000 to 0.

Any other thoughts.

Thanks.
--
ndd


"keithl816" wrote:

>
> Hi Neil,
>
> Recheck your formula. I tried what you wrote and it worked for me. You
> might want to Right click the cell in question and try Number/Text.
>
>
>
> Hope this helps
>
>
> --
> keithl816
> ------------------------------------------------------------------------
> keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
> View this thread: http://www.excelforum.com/showthread...hreadid=381563
>
>

Can you post an sample of your spreadsheet?