stevelucky
Board Regular
- Joined
- Oct 6, 2006
- Messages
- 126
i have a cell that contains the formula: =I4*0.02
i want to be able to copy the generated number from that cell and paste it into another cell. but when i copy it, it obviously just copies the formula and pastes that. any ideas?
i.e. - the formula in that cell generates the number, "10". i want to be able to copy that cell and paste "10" into another cell, instead of copying the formula, =I4*0.02.
i want to be able to copy the generated number from that cell and paste it into another cell. but when i copy it, it obviously just copies the formula and pastes that. any ideas?
i.e. - the formula in that cell generates the number, "10". i want to be able to copy that cell and paste "10" into another cell, instead of copying the formula, =I4*0.02.