Re: [AI] Excel query, very urgent
Do a "Paste special" instead of "paste" and select "value only". You will get the "paste special" command in the right click context menu and under the edit menu in excel. -Manish -Original Message- From: accessindia-boun...@accessindia.org.in [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Vamshi. G Sent: Wednesday, February 09, 2011 8:32 PM To: accessindia Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org >From darkness unto light Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] Excel query, very urgent
Hello Vamshi, After coping the cell please use paste special command. Then select values--Press enter. Done! The actual value will appear in that particular cell instead of formula. Try it. Regards Mukesh Baviskar Mobile: 9403161157 -- From: "Vamshi. G" Sent: Wednesday, February 09, 2011 8:32 PM To: "accessindia" Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] Excel query, very urgent
Ensure that the cell coordinates in the formula pasted at the new location do not overlap. This error normally occurs when you paste the formula into a cell which is also included in the formula's calculation. In other words, if you are adding up A 6 to A10 and paste the formula into A10, you are likely to get this error. Geetha - Original Message - From: "Vamshi. G" To: "accessindia" Sent: Wednesday, February 09, 2011 3:02 PM Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org >From darkness unto light Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
[AI] Excel query, very urgent
Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org >From darkness unto light Get numbers right this time, help the census with correct disability info!