Impossible to calculate anything in cells. Getting #VALUE error all over the table.

[Kizuna]

Hello,

I'm trying to calculate the product =100*A3 , but I get the #VALUE error. What's more, I'm getting this error in all cells in which I'm trying to do some sort of mathematical operation. I have tried setting the cells to number value mode, as well as using =PRODUCT(100,A3) (in fact, I'm using Excel in Spanish, so it would be: =PRODUCTO(100,A3) ). Besides, the error is not due to having a space before the value, either. The most weird thing is that this problem just happens in two of the four sheets of my Excel file. That's why I have also tried checking whether the cell format is different in each sheet, but it appears to be the same in all of them.

Moreover, although I have checked some websites regarding this issue, I feel they don't have the answer to my problem. Here are some of the links I have had a look at (the others are in Spanish, so I don't think it's worth posting them here):

https://support.office.com/en-us/ar...UE-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e

http://www.mrexcel.com/forum/excel-...ved-linked-cells-when-data-source-closed.html

http://www.mrexcel.com/forum/excel-questions/510783-troubleshooting-sumproduct-value-error.html

Resolving #VALUE! Errors in Microsoft Excel | AccountingWEB


By the way, I'm using Microsoft Excel 2010 Professional. I'm not an expert on Excel, as I have only used to do some basic calculations, so it's quite possible this problem is easy to solve. There might be an answer to my problem somewhere on the Internet, but I haven't been able to find anything. Please tell me if it's necessary to add anything else to the post.

Thank you very much for your attention and sorry for the inconvenience

Happy New Year's Eve/ New Year to everyone on the forums!

 

[Kizuna]

After copying and pasting as values, the data keeps the same format and isn't still a number. :/ When you said to check the add ratio button, I suppose you meant to click on the "Paste as values" button, right? I have looked up what the "Add ratio" buttons are, and I don't see how it's related to this. https://www.extendoffice.com/documents/excel/914-excel-insert-radio-button.html

 

[MARK858]

No the Add radio button in the operation section near the bottom (the check box next to Add) not as values.

 

[Kizuna]

If you mean just checking the "Add" box in the operation section of the "paste special" menu (see link), nothing is pasted. The cells are blank after doing this. http://www.excel-easy.com/examples/images/paste-options/paste-special-dialog-box.png

 

[MARK858]

You select the columns with the data (columns A-C), You copy a blank cell from somewhere else on the sheet), you do not have values checked (All should be), you right click, check paste special, select Add and OK.

If the cells are blank then you had values checked (which you were not advised to do).

You shouldn't see anything pasted it is how the formulas react we are interested in.

 

[Kizuna]

Oh, I think I know what you mean now. I have copied a blank cell, right clicked on the columns A-C and then clicked on "paste special", but nothing has changed.

 

[mole999]

was that paste special > Operation ADD ?. The idea is to force a calculation and therefore PROPER Numbers

 

[Kizuna]

Yes, that's what I did mole999. However, it didn't work. Thank you all for your help. Eventually, I ended up copying the values one by one in another table in order to make the cells be in value format.