Formula always Returns 0

[surkdidat]

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 there was stopping it.

Any other suggestions, would be helpful!

 

[Joe4]

Yes, I tried that, and saved in that format, to no avail.

Did it allow you to save it as an "XLSX", or did it give you an error?

 

[surkdidat]

There were no issues saving in in XLSX format

Did it allow you to save it as an "XLSX", or did it give you an error?

 

[Joe4]

OK. Thanks for confirming. That just confirms VBA remnants were not the issue.