Entering numbers consecutively in same formular cell and want the value saved to another cell without having to copy and paste value only. eg a2=a1*2. enter values in a1 1.2.3 etc and want values saved to other cells.Disd it once and forgot how!! cheers.