Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pasting problem
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pasting problem
Hi,
When you copy the cells in sheet1 and paste it in a cell of sheet2 before pasting right click on that cell paste specialcheck the radio button of valuesok. By doing this you'll paste the value instead of the formula. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Niroo" wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pasting problem
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 "Suleman Peerzade" wrote: Hi, When you copy the cells in sheet1 and paste it in a cell of sheet2 before pasting right click on that cell paste specialcheck the radio button of valuesok. By doing this you'll paste the value instead of the formula. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Niroo" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting problem | Excel Discussion (Misc queries) | |||
Pasting problem | Excel Discussion (Misc queries) | |||
Problem with pasting | Excel Discussion (Misc queries) | |||
pasting and one other problem | Excel Discussion (Misc queries) | |||
Problem Pasting | Excel Discussion (Misc queries) |