Copy and paste information from a cell to ano

Closed

donovan - Feb 22, 2011 at 01:37 PM
RayH - Feb 22, 2011 at 06:44 PM

i am just wondering how to copy and paste information from a cell to another document.
i have a formula to figure out the sum of total boxes and i want to paste it into another document to figure out skid counts for me my formulas are fine but when i paste it from document 1 to document 2. it gives me a zero value. is there any way to show the numerical value instead of the o value.. ie: =A2:A46/27, Then i want to paste this into a second document but when i paste it into the second document it keeps showing me a zero value instead of the numerical value. Please help.

Copy and paste information from a cell to ano
Copy and paste fonts - Guide
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Conditional formatting if cell contains text - Excel Forum
Count if cell contains number - Excel Forum

1 response

Answer 1 / 1

RayH
Feb 22, 2011 at 06:44 PM

in the 2nd document, Paste Special, Values. Its likely that the cells A2:A46 are blank in the 2nd document

Similar discussions

Can no longer paste text into insta

How can I make my name text invisible in Discord

If a cell contains any text then add a value

help me to add particular cells

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!