Transferring stat data

Milt

New Member
Joined
Aug 31, 2002
Messages
2
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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
one way:

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


Does that do it?

Paddy
 

Forum statistics

Threads
1,143,702
Messages
5,720,374
Members
422,280
Latest member
scottylan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top