Go to format cell and sett the cell option to general. Then press enter and
hit F2
G.

"Nad" wrote:

Hi,
In Sheet2,Cell E2 , I am using Sheet1!E2.

But i am not getting the result. It is displaying as =Sheet1!E2 (as text
entry)

I don't know what wrong with this formula.

Please help in this regard.

Best Regards,