You can highlight and copy the range then re-highlighting an equivalent area select paste special. In the additional dialog ensure that only 'numbers' is selected, then OK. The results of the formulas will then be pasted into the cells.
/paul On 5/12/05, Bob Lockie <[EMAIL PROTECTED]> wrote: > I have a bunch of formulas that are just references to other parts of > the spreadsheet and I have decided that instead of reference I actually > want to copy the data. > Is there an easy way to do this? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
