Pasting problem

[Niroo]

Hi,

I am new to excel and i am trying to paste some data from a table this table
is in sheet 1 of my workbook. What i am not able to do is whenever i paste
the data in required cell in sheet 2 it gives back formulas to me instead of
the actual figures that i can see over here.
Any clue why is it happenning.

 

[Suleman Peerzade]

Hi,

When you copy the cells in sheet1 and paste it in a cell of sheet2 before
pasting right click on that cell >>paste special>>check the radio button of
values>>ok.
By doing this you'll paste the value instead of the formula.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Mike Rogers]

I think the underlying problem might be that the cells you are pasting to are
formated as Text. Check them and make sure they are formated to General
BEFORE you paste from Sheet 1.

Mike Rogers