status bar autocalc not calcing pasted values!

[leecavturbo]

pasted some numbers and highlighting a few cells i get no sum of in the status bar!?
2003/xp no other books open no vb
retyping the values allows auto summing! ?

 

[leecavturbo]

??????????

 

[leecavturbo]

really stuck on this still

 

[leecavturbo]

anyone

 

[xenou]

It's a problem that occurs in some cases and I really don't know the cause yet - apparently something in the data tells Excel "this is text data" rather than "this is numeric data".

workarounds are

1) For formulas pasted in Find/Replace the equals sign
        Find: =
        Replace with: =

2) For numbers pasted in add zero
        Copy a zero from any cell
        Select the data you pasted in
        Paste Special | Add

 

[leecavturbo]

thx X. yes its quite bizarre. checked all the obvious formatting/paste special etc

 

[leecavturbo]

any joy people? got stumped by this issue again

 

[leecavturbo]

no fix ?

 

[leecavturbo]

does 2010 have this issue too?