I have a yearly figure in cell a1. I do not need that number but I do need the monthly number. I have info in many columns and was trying to save a column.
I can stop the formula from continiously refiguring by setting under tools, options, calculate, the iterm to 1. Thus it will only calculate once.