Forum Discussion
Iteration, Absolute copy, Format significant digits
Hi - thanks in advance for any help on any one of these three operations - these operations are very important to me (and maybe others): 1) Iteration - Assume B1 = sin(A1); A1 = B1 - 0.1; I ne...
- What have you tried yourself so far?
- A trick I sometimes use is this:
- Select the cells you want to copy
- Press control+H to open the Replace dialog
- Find the = sign and replace with a character not otherwise in the formulas, like the | character or the @
- Copy the (now plain text) cells
- Paste them
- Do the replace operation again reversing the find and replace with characters
- Perhaps this article helps: https://jkp-ads.com/articles/round2digits.asp
This is a very lengthy sequence of operations. I need at most one click or two clicks.
Pls. read my original post and it explains how I do it, which is not too different from yours.
Pls. read my original post and it explains how I do it, which is not too different from yours.