Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert formulas to values
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert formulas to values
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" <MatthewFlinchem.27yk41_1147879813.743@excelforu m-nospam.com wrote in message news:MatthewFlinchem.27yk41_1147879813.743@excelfo rum-nospam.com... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert formulas to values
Copy, Paste Special, check Values
-- Kind regards, Niek Otten "MatthewFlinchem" <MatthewFlinchem.27yk41_1147879813.743@excelforu m-nospam.com wrote in message news:MatthewFlinchem.27yk41_1147879813.743@excelfo rum-nospam.com... | | 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 | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert formulas to values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard values to convert to number | Excel Discussion (Misc queries) | |||
Changing values but not formulas | Excel Worksheet Functions | |||
Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
How do I sum rounded values from two seperate formulas in Excel? | Excel Worksheet Functions | |||
How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions |