May 10 2023 10:41 AM
May 10 2023 01:50 PM
I agree with @Hans Vogelaar : it would be best to attach an Excel file or provide a link to an Excel file that demonstrates the problem.
But we might guess that what appears to be 0.61% and -0.31% are text, not numeric values.
Looks can be deceiving, and the format of the cell does not matter. Use formulas of the form =ISTEXT(A1) to confirm my suspicion.
As for "why?", we might not even be able to determine that by looking at an Excel file.
The most likely reason might be: you should write 0,61% and -0,31%. In other words, your system configuration requires a comma for the decimal point, not a period.
But there might be a myriad of other reasons. For example, there might be errant characters in the cell, especially if you copy-and-pasted from webpage.