This is in one of my cells:
1.16518E+11
I think there are not enough characters allowed to show it, but I'm not sure how to allow more characters so it will appear as the huge value of 116517955584
2006-11-28 09:46:20 · 3 answers · asked by Neophyte 3 in Computers & Internet ➔ Software
I have already dragged the column as far as it can go width-wize. The E thing doesn't go away.
2006-11-28 09:57:54 · update #1
I need to format the cells. I believe it will only allow, say, 7 characters within each cell (for example) and I need like 22 or something like that. Any suggestions how I can get more characters in each cell?
2006-11-28 10:00:19 · update #2
Sayee got it!
That's what the problem was. Thank you!! I'll give Sayee the full 10 pts. for answering it.
2006-11-28 10:02:10 · update #3
Right click on the cell, click format cells, choose number on left hand side and change decimal places to 0.
Hope this helps.
2006-11-28 09:51:02 · answer #1 · answered by Sayee 4 · 1⤊ 1⤋
Just grab the right wall of the cell (or column) with your cursor and drag it to the right until the numbers show.
2006-11-28 17:49:13 · answer #2 · answered by bogus_dude 6 · 1⤊ 1⤋
you can also place your cursor at the top of the colum where the next colum starts (pretty much on the line) and double click. it will expandit to the length of the longest cell in that colum.
2006-11-28 17:50:23 · answer #3 · answered by Anonymous · 0⤊ 0⤋