OMG I think i'm going to lose my mind. I am trying to enter a 16 digit number into a cell in excel and it keeps converting it into a bizarre number. Example, if I enter 5555000044446666 as soon as I tab out of that cell, it turns into 5.555E+15. I have tried "format cells" using General, Number, Text and everything else and it keeps doing this. What the crap?
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.