if I enter 123456789101112131416
I get 1234567E+22
I want it to show the whole number I entered. I tried changing the cell property but it would shoud 123456789111200000000
how do i make it to show exact number i entered in? Thanks
2007-02-27 14:14:30 · 3 answers · asked by PhantomX 1 in Computers & Internet ➔ Programming & Design
There is no other way other then appending ' to the number?
Thanks thanks
2007-02-27 14:20:06 · update #1
Excel only has 15 digit number precision. So you'll only get that many digits no matter what you try, unless you make it a text cell. But doing that won't allow some math functions.
2007-02-27 14:20:20 · answer #1 · answered by BigRez 6 · 1⤊ 0⤋
right click the cell and change the format to general or numbers
2007-02-27 22:20:44 · answer #2 · answered by WowCrafter 4 · 0⤊ 1⤋
Change it to a character field by prepending a ' to it. For example
'122233444555666666...
2007-02-27 22:18:11 · answer #3 · answered by Anonymous · 0⤊ 0⤋