Hi
Pls look at attached spreadsheet. I have a formula in cell A1 to paste text together in order to arrive at "=1+2". I then Paste Value cell A1 into Cell A2. When I do so, cell A2 now contains "=1+2" but it doesn't return the value "3" unless I go into the cell and hit <Return>. Is there a way for me to make cell A2 automatically return "3" when I Paste Value without having to go into the cell and hit <Return>?
I am doing it this way as I need to create many lines of formulas conveniently by pasting text together.
thanks
Bookmarks