i have a problem on excel formula like following:

='Sheet-A'!B56

the problem is, it will not display the value of 'Sheet-A'!B56 in a special
cell which in another sheet. the cell has been copied from itself once.
before then, everything ok, it show the value of 'Liquor-List'!B56. but after
copied from itself, it just disply "='Sheet-A'!B56". other cells which not be
copied still ok. anybody has any suggestion?

Thanks.

Your cell is probably formatted as Text. Select the cell and click
Format | Cells | Number tab and choose General, then double-click the
cell as if to edit it, then press Enter.

Hope this helps.

Pete

Steven.Xu wrote:
> i have a problem on excel formula like following:
>
> ='Sheet-A'!B56
>
> the problem is, it will not display the value of 'Sheet-A'!B56 in a special
> cell which in another sheet. the cell has been copied from itself once.
> before then, everything ok, it show the value of 'Liquor-List'!B56. but after
> copied from itself, it just disply "='Sheet-A'!B56". other cells which not be
> copied still ok. anybody has any suggestion?
>
> Thanks.

Thanks Pete_UK, you are right. it has been fixed. but i should do this job
through VBA. is it possible do it easily? why other cells what be copied is
ok?

Thanks again.

"Pete_UK" wrote:

> Your cell is probably formatted as Text. Select the cell and click
> Format | Cells | Number tab and choose General, then double-click the
> cell as if to edit it, then press Enter.
>
> Hope this helps.
>
> Pete
>
> Steven.Xu wrote:
> > i have a problem on excel formula like following:
> >
> > ='Sheet-A'!B56
> >
> > the problem is, it will not display the value of 'Sheet-A'!B56 in a special
> > cell which in another sheet. the cell has been copied from itself once.
> > before then, everything ok, it show the value of 'Liquor-List'!B56. but after
> > copied from itself, it just disply "='Sheet-A'!B56". other cells which not be
> > copied still ok. anybody has any suggestion?
> >
> > Thanks.
>
>

I try to convert the source cell to general format. the destination display a
right value after copy. that's all right. but there has another problem is
the source cell should be displaied a barcode. if the format is general.
excel will ignorl the 0 in front of the barcode. that's the new problem. how
can i do then?

Thanks.

"Pete_UK" wrote:

> Your cell is probably formatted as Text. Select the cell and click
> Format | Cells | Number tab and choose General, then double-click the
> cell as if to edit it, then press Enter.
>
> Hope this helps.
>
> Pete
>
> Steven.Xu wrote:
> > i have a problem on excel formula like following:
> >
> > ='Sheet-A'!B56
> >
> > the problem is, it will not display the value of 'Sheet-A'!B56 in a special
> > cell which in another sheet. the cell has been copied from itself once.
> > before then, everything ok, it show the value of 'Liquor-List'!B56. but after
> > copied from itself, it just disply "='Sheet-A'!B56". other cells which not be
> > copied still ok. anybody has any suggestion?
> >
> > Thanks.
>
>