Converting Equations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I take an equation and convert the answer to an actual number
example - =a5*2 the answer lets say is 6. I want the 6 to show up as an actual number, so I can then take it and move it to other spreadsheets, without having to take the whole equation.
 
Copy, edit>paste special as values

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


makler said:
How can I take an equation and convert the answer to an actual number
example - =a5*2 the answer lets say is 6. I want the 6 to show up as an
Click to expand...
actual number, so I can then take it and move it to other spreadsheets,
without having to take the whole equation.
 
Hi

Copy it, and then PasteSpecial.Values from Edit menu or from right-click
dropdown menu.


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


makler said:
How can I take an equation and convert the answer to an actual number
example - =a5*2 the answer lets say is 6. I want the 6 to show up as an
Click to expand...
actual number, so I can then take it and move it to other spreadsheets,
without having to take the whole equation.
 
If you still want to *retain* the original formula in the original sheet,
you could copy it to another cell, and then copy this cell to itself as a
value. and then copy the value to this new sheet.

*Select* the *entire* formula in the formula bar,
Right click the selection and choose "Copy",
Hit <Enter>.

Click in an empty cell and "paste".

You now have a duplicate formula that you can convert to a value.
Right click in this duplicated cell and choose "Copy".
Right click again, and choose "Paste Special".
Click "Values", then <OK>.

This cell is now a value, which you can copy to "wherever".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How can I take an equation and convert the answer to an actual number
example - =a5*2 the answer lets say is 6. I want the 6 to show up as an
actual number, so I can then take it and move it to other spreadsheets,
without having to take the whole equation.
 
when you copy the forula, use paste special function and
choose "value"
-----Original Message-----
How can I take an equation and convert the answer to an actual number
example - =a5*2 the answer lets say is 6. I want the 6
Click to expand...
to show up as an actual number, so I can then take it and
move it to other spreadsheets, without having to take the
whole equation.
 
Back
Top