-
My number value is overwritten by #NUM!
over 8 years ago
The column which now shows #NUM! had values like 20000, 4000. It earlier had values like mentioned above. I copied a row, pasted it in another row and darn! It got messed up... FYI- This sheet uses Tables.
![](javascript:showImageData("https://findnerd.s3.amazonaws.com/imagedata/3492/240x160/3492.png","blog8") "Click to preview"){kind=small}
-
over 8 years ago
You must have used a formula to calculate values in the cell that show the #NUM! error. Most probably the formula includes SQRT of a number and that number is a negative number. Square root of a negative number is not real, and probably because of that this error message shows.
-
-
over 8 years ago
Apurva, thanks. I have already seen that link but in vain.
-
-
over 8 years ago
Hi,
Did you check whether you have turn on the error check on your excel , if yes then click (on error icon) next to cell which show the error. Click show calculation steps if available, and pluck the solution for your data.
for more you can take help from
http://findnerd.com/list/view/How-to-solve-NUM-error-in-excel/11822/
-
-
over 8 years ago
there can be more than one reason for this error.
Check this link
https://support.office.com/en-us/article/Correct-a-NUM-error-f5193bfc-4400-43f4-88c4-8e1dcca0428b.
-
4 Answer(s)