Couple quick questions for the experts
Posted by V8GS on November 22, 2001 11:22 PM
Hello all
Couple of quick questions for Xp Office
How do I change the numbers on top back to letters?
When I input long numbers into a cell it converts it to a shortened version with letters. How can I keep the long numbers in the cell intact?
thank you in advance
Posted by Walter on November 22, 2001 11:43 PM
I'm using old Office 97 but I think it should be the same.
1. If you find that the column headings are numbers instead of letters, you are using "R1C1 reference style". Go to Tools -> Options -> General , and clear that checkbox.
2. I believe what you get is something like 1.234E+05. That's scientific expression of a large number. Change the format of the cell to number e.g. "0." or increase the width of the cell.
Posted by V8GS on November 23, 2001 12:27 AM
Thank you Walter, the first solution you offered worked great ,thank you.
Now on the second one, even if I use FORMAT to change the cell to numbers and increase the cell width, if I enter long number, now I get a bunch of zero's in place of the numbers I placed. For example:
I type in :
5635635635635756784857835626
Excel converts it to:
5635635635635750000000000000
How can I change this to show EXACTLY what I type in?? thank you ,Lee
Posted by Walter on November 23, 2001 3:27 AM
No, you can't.
In general, numbers are stored in computer using floating point number format. In current specification, the maximum number of significant digits is 15. Excel also follows that rule and therfore, only the first 15 most signigicant digits are stored.
PS:If Excel use integer to store numbers, you cannot get any integer with more than 12 digits. Floating number can give a much larger range.
