Converting Formula into Numbers?

[Emp-Designer]

With a cell/s selected is there a way to convert the cell's formula into
straight numbers (in turn removing all formula and leaving the same
number)?

 

[FxM]

Emp-Designer a écrit :

With a cell/s selected is there a way to convert the cell's formula into
straight numbers (in turn removing all formula and leaving the same
number)?

Hi,

First keep the original in safe place. Work on copy if ever ...
select - copy - paste special (values)

HTH
FxM

 

[Pete_UK]

With the cell(s) highlighted, click <copy> then Edit | Paste Special |
Values (check) then OK and <Enter> or <Esc> to fix the values in the
same cells.

Hope this helps.

Pete

 

[Niek Otten]

Edit>Paste Special, check Values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| With a cell/s selected is there a way to convert the cell's formula into
| straight numbers (in turn removing all formula and leaving the same
| number)?
|
|
| --
| Emp-Designer
| ------------------------------------------------------------------------
| Emp-Designer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37564
| View this thread: http://www.excelforum.com/showthread.php?threadid=571948
|