Transferring stat data

[Milt]

We are working with a data base whose entries need to be standardized or normalized. This we have done by multiplying each cell by a related value (we're working with body proportions and multiply the humerus length by the measurement in question). Now we need to perform an ANOVA test on the results. The problem is that we can't transfer the data to a new worksheet because the program reads the data as a formula (i.e. C4*12.234). How can we change the formula to a real number and then copy it to a new worksheet? Thanks much.

 

[PaddyD]

one way:

select the data, copy, select the destination, paste special...values.


Does that do it?

Paddy

 

[Milt]

Yes, thank you, thank you, thank you.