When I type a simple formula into a cell, example =2/4*10, then hit enter and go to another cell, then go back, the cell that had a formula will just have a value of 5 with no formula in the forumula box.
There doesn't seem to be any logic to when it occurs, may be a spreadsheet someone sent to me or a new one I created. How can I make this stop? Even though it is a simple formula, I want to be able to see the different numbers, not just the result of the formula.
Rob
There doesn't seem to be any logic to when it occurs, may be a spreadsheet someone sent to me or a new one I created. How can I make this stop? Even though it is a simple formula, I want to be able to see the different numbers, not just the result of the formula.
Rob