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.