Hi Jim,
As you posted your question in the Numbers for Mac community, and provided no information regarding the device or operating system you wee using, my response was geared toward accomplishing what you asked using Numbers on a Mac.
Here are the instructions from an Apple Support page regarding copying and pasting in Numbers for iPad:
When the keyboard is closed, you can copy a formula, or just the result, from one cell to another.
- Tap the cell with the formula you want to copy, tap it again, then tap Copy in the contextual menu.
- Tap the cell where you want to paste the formula or the result, tap it again, then tap Paste.
- To preserve the formula, tap Paste Formulas, or to paste only the result, tap Paste Values.
Posting an iPad Numbers question here is fairly common, probably due in part to Apple's decisions regarding labeling the communities. While the three Mac applications—Pages, Numbers and Keynote—that were, at one time packaged as a set named iWork, the iOS versions for Pad and iPhone were never (to my knowledge) promoted or packaged as "iWork".
Except here, where Pages, Numbers and Keynote (for Mac) each have their own community, named for the individual application, the iOS versions of the apps are all placed in a community named "iWork for iOS".
To get there from the Support Communities front page, you nee to scroll down a couple of pages to a link for "More communities", click it, then find the Work symbols: 
click the link under the image to get here:
and click the link furthest to the right in that row.
Once you get to the iWork for iOS community, you might want to bookmark it—in case of more questions in the future.
Regards,
Barry
PS: If you don't get an answer there, you can always repost your question here. The Mac and iOS versions are different, but there's enough common ground between them that many questions can be answered in either place.
Regards,
Barry
