convert formulas to values

[MatthewFlinchem]

I have a huge spreadsheet that has a formula in every cell. I want to eliminate the formulas and just leave the results. I am sure this is an easy step but I am lost!

Thanks,

Matt AKA Dr Evil

[Paul B]

Matt, select the cells you want to change, right click and copy, right click
and paste special, check valve OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"MatthewFlinchem"
<[email protected]> wrote in
message news:[email protected]...
>
> I have a huge spreadsheet that has a formula in every cell. I want to
> eliminate the formulas and just leave the results. I am sure this is an
> easy step but I am lost!
>
> Thanks,
>
> Matt AKA Dr Evil
>
>
> --
> MatthewFlinchem
> ------------------------------------------------------------------------
> MatthewFlinchem's Profile:
> http://www.excelforum.com/member.php...o&userid=34112
> View this thread: http://www.excelforum.com/showthread...hreadid=542955
>

[Niek Otten]

Copy, Paste Special, check Values

--
Kind regards,

Niek Otten

"MatthewFlinchem" <[email protected]> wrote in message
news:[email protected]...
|
| I have a huge spreadsheet that has a formula in every cell. I want to
| eliminate the formulas and just leave the results. I am sure this is an
| easy step but I am lost!
|
| Thanks,
|
| Matt AKA Dr Evil
|
|
| --
| MatthewFlinchem
| ------------------------------------------------------------------------
| MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112
| View this thread: http://www.excelforum.com/showthread...hreadid=542955
|

[SVC]

Select the entire worksheet, then Copy, then Edit >Paste Special, and select
Value. This will convert all formulas to values.

"MatthewFlinchem" wrote:

>
> I have a huge spreadsheet that has a formula in every cell. I want to
> eliminate the formulas and just leave the results. I am sure this is an
> easy step but I am lost!
>
> Thanks,
>
> Matt AKA Dr Evil
>
>
> --
> MatthewFlinchem
> ------------------------------------------------------------------------
> MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112
> View this thread: http://www.excelforum.com/showthread...hreadid=542955
>
>