I want to copy the contents of a cell that is the result of a formula to a new location as a rational number. How can I do that?
Hi @doozer449,
If you’re trying to manually copy the contents of a single cell to a new location, you can use the “Paste Special” functionality:
- Copy the contents of a cell (I’m using a cell with the value “6” generated by the formula =2+4)
- Right-click on a new cell, and select “Paste Special”
- Under “Selection”
- Uncheck “Paste All”
- Make sure that “Formulas” is unchecked and that “Numbers” is checked.
- Confirm that your new cell contains the number “6” as a simple number, with no formula present.
is there a function if I want to use the number (which is the result of a formula) in another formula?