it seems that any formula that i enter in a workbook and paste to other cells
does not carry over as it takes the value in the original cell. this just
started happening today and i'm not sure if the formula settings were somehow
changed? please help. thanks to all