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!

 

[Special-K99]

Whats the formula thats returning 0 ?

 

[surkdidat]

It is literally anything. Even putting "AAA" in ce A1 and then in A2 putting =A1 will bring up a 0 answer

Whats the formula thats returning 0 ?

 

[Joyner]

Does this happen with every workbook or just one?

The only thing I can think of is to check the formatting, if it is Custom change it to General

 

[Joe4]

Try saving as an XLSX file to make sure that you really got rid of all VBA (if you didn't, it won't let you save to an XLSX - that would be an indication that you missed something!).

Also, I would re-emphasize Joyner's question. What happens if you try this on a new workbook? Does it show the same behavior, or is it just this one workbook?

 

[surkdidat]

I will try this again today. Transferring all of this over to a new workbook will take sometime as there are around 30 sheets to transfer. If I open a completely new workbook, formulas work fine, and there are no issues...

Try saving as an XLSX file to make sure that you really got rid of all VBA (if you didn't, it won't let you save to an XLSX - that would be an indication that you missed something!).

Also, I would re-emphasize Joyner's question. What happens if you try this on a new workbook? Does it show the same behavior, or is it just this one workbook?

 

[Joe4]

Were you able to save your current file as an XLSX?

 

[surkdidat]

I have copied everything across and seems to be working in a new workbook for some reason!

Were you able to save your current file as an XLSX?

 

[Joe4]

I have copied everything across and seems to be working in a new workbook for some reason!

OK, but that is not what I was asking you to do. I was trying to help you identify the cause of your issue.
I was asking you to try and save your CURRENT file as an XLSX. If it does not allow you to do that, it probably means you missed some VBA somewhere.

 

[surkdidat]

Hi Joe
Apologies - Yes, I tried that, and saved in that format, to no avail. I have no idea what happened as when I went to my last resort and put into a new work book, everything worked fine! Thanks for trying to resolve the issue though

OK, but that is not what I was asking you to do. I was trying to help you identify the cause of your issue.
I was asking you to try and save your CURRENT file as an XLSX. If it does not allow you to do that, it probably means you missed some VBA somewhere.