Question: long numbers are displayed incorrectly in excel?
Answer: Right-click target cell, and then click Format Cells.
On the Number tab, select Text, and then click OK.
Then type a long number. ( Be sure to set the cell format before you type the number)
If you do not want to see the warning arrows, click the small arrow, and then click Ignore Error.