how do you copy excel numbers from a spreadsheet without copying over the code?

Copy as normal, however, instead of just pressing 'Paste' in the new spreadsheet, right-click where you want to paste and choose Paste Special. Check the box for Values and only the values will be pasted, not everything else.

1. (The obvious) - Make sure that you've entered in all the same numbers that you are keying into your calculator. 2. Make sure your formula is capturing the whole range of numbers. You didn't give the formula, but it might look like this: =SUM(A1:A100) 3. Sometimes cell formatting hides the actual value of the cell. For example, standard formatting to 2 decimal places rounds the number to 2 decimal places for display purposes ONLY, the real value is still there and is used in calculations. Try increasing the number of decimal places in your number formats so you can see how many places your numbers have. Go to >Format>Cells>Number To check if each column is the same, try typing in the third column =A1=B1. This will say "False" if A1 does not match B1. Another handy trick: when you highlight a range of numbers, the sum of those numbers will appear in the bottom right of the Excel window. (btw, you can change this to show you max, min, count and others instead). This is useful when checking formulas. Also - make sure all the cells are recognized as numbers, and aren't preceded by '.

You need to copy the numbers to the clipboard (left mouse button click and drag, then right mouse button within the selected area and select copy) and then go to a fresh sheet or other available cells, and then right click on a blank cell and select Paste Special, then select Values. This will not copy the formulas, just the values.

Copy, then when you go to paste, click edit > paste special. There should be an option to paste the numbers only or something like that.

Copy and select paste special and select values. Try the other options under paste special of that doesn't work.

Copy

Paste Special (Right click, or go to "Edit" then Paste Special)

Select "Values"

Click OK

This should paste just the values unless I've missed a step.

Say you have a number in "Sheet 1" cell "A1", you want to copy just that number into "Sheet 2" cell "A1":-

In "Sheet 2" cell "A1", type "=Sheet1!A1" (without the "s)

Now, everytime the number changes in "Sheet 1" cell "A1", the number will change in "Sheet 2" cell "A2".

Hope it helped, sorry if it didn't, this is what I think you were asking for and other answers were different.

edit-copy

edit - paste special - values