Turn off Exponential Notation Part 2

J

JeremyO

I want to turn off exponential notation.

At 15 places, the calculation goes haywire.

For instance, if I type 2^50, I get 1125899916842620, when the value should be 1125899916842624.

See my problem? At 15 places, zeros are added to save data space. I do not want this and just want the full value.

How do I turn that off?
 
M

Myrna Larson

Excel has a limit of 15 digits of precision. That's why the 4 is changed to a
0. Before you complain about this, what's at work here is the IEEE
specification for representation of floating point numbers in 8 bytes. If you
need more than 15 digits, Excel isn't the right app for you.


I want to turn off exponential notation.

At 15 places, the calculation goes haywire.

For instance, if I type 2^50, I get 1125899916842620, when the value should be 1125899916842624.

See my problem? At 15 places, zeros are added to save data space. I do not
Click to expand...
want this and just want the full value.
 
J

JE McGimpsey

It's not exponential notation. XL's built-in precision limit is 15
decimal digits. After that, you'll get approximate values...

You can do a Google search for add-ins that claim to give up to 200
digits of decimal precision, but I've never used them.
 
J

JeremyO

All right. Precision is the proper term. I have done the search and attempted to use "Xnumbers" as an add-in for excel. It doesn't work, and I've looked all over trying to find something else. Short of buying or pirating MATLAB, I don't see a way around this problem. I know how to manually calculate the numbers, but would like very much to find a good add-in. Hmm.... Any suggestions, anyone?
 
B

Bernard Liengme

The URL for XNUMBERS is http://digilander.libero.it/foxes/index.htm

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


JeremyO said:
All right. Precision is the proper term. I have done the search and
Click to expand...
attempted to use "Xnumbers" as an add-in for excel. It doesn't work, and
I've looked all over trying to find something else. Short of buying or
pirating MATLAB, I don't see a way around this problem. I know how to
manually calculate the numbers, but would like very much to find a good
add-in. Hmm.... Any suggestions, anyone?
 
Top