Converting Formula into Numbers?

E

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)?
 
F

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)?
Click to expand...


Hi,

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

HTH
FxM
 
P

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
 
N

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
|
 
Top