Can someone help!
I have even erased the formula and put =A1 and put a value n A1 t see if a problem with y original formula (which incidentally used to work fine!)
It is not set as a text field, the sheet is on automatic calculation, I have stripped all VBA out of it just in case something in...