Not reading pasted values?

[J.W. Aldridge]

I have had this problem a few times before and I haven't been able to
find the answer...
I had a list of formulas and results in the column next to it (B).
I copied the values into another list (C) and now am referring another
set of formulas (d) to point at the pasted results. The new formula's
dont work (#N/A - error) unless I go down to each pasted value and
click in that cell and hit enter.

It's like saying that the cell values aren't real until I validate
them by hitting enter in those cells?

 

[Niek Otten]

Not too many details.......

Try Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have had this problem a few times before and I haven't been able to
| find the answer...
| I had a list of formulas and results in the column next to it (B).
| I copied the values into another list (C) and now am referring another
| set of formulas (d) to point at the pasted results. The new formula's
| dont work (#N/A - error) unless I go down to each pasted value and
| click in that cell and hit enter.
|
| It's like saying that the cell values aren't real until I validate
| them by hitting enter in those cells?
|

 

[J.W. Aldridge]

Found the answer!

TomOgilvy had previously answered a similar question....

It was reading my numbes as text.

If I copy a blank cell, and paste special over my list of numbers,
choose Operation - add, it turns them back into numbers.



Thanx anyway....