Forum Discussion

wmoula's avatar
wmoula
Copper Contributor
Jan 22, 2019

Excel eror or bug ?

Dear ,

I am calculating a simple formula in excel but I am getting in error as you can see in the attached screen shot.

 

Please check and advice if it is a bug or not > and how to fix it ?

 

Regards

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Cell J6 appears to contain a number, but Excel thinks it is text. Select that cell and Excel should display a small widget (a tiny yellow square with a black exclamation mark in it) next to the cell. Click it and select the option "Convert to number".

Resources