Excel Calculate #N/A

Environment
  • Microsoft Excel 2003
Problems
Although both cells are number, the result (A1 + B1) is still #N/A

Solutions
Create a new cell
A1 * 10 /10
Copy the result to the cell