When I enter a long number, it overlaps into the next cell. However, I do
not get the # sign. Instead, a type of formula appears. For example if I
entered 22222222222222 (14 2's), what appears is 2.22222E+14. Why does it do
this? Or, if I select that column, right click then choose Format Cells and
change to Number Format, the cell width automatically adjusts itself. Is
there somewhere in Excel Options I can change this? What am I doing wrong?