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.