Sig Figs

[Alterac]

I am working with a series of complex equations. I need them to carry a
constant 4 significant figures throughout the entire spread sheet until it is
rounded at the end. My issue is that I cannot get them all to show.

IE:
1) 0.0389
2) 0.2345
These are two different values that hold two different significant figures.
How do I get excel to show all the sig fig’s since the rounding function
seems to be limited.
Thanks for all the help!

P.s. I dont know a lot about macros....

 

[Ron Rosenfeld]

I am working with a series of complex equations. I need them to carry a
constant 4 significant figures throughout the entire spread sheet until it is
rounded at the end. My issue is that I cannot get them all to show.

IE:
1) 0.0389
2) 0.2345
These are two different values that hold two different significant figures.
How do I get excel to show all the sig fig’s since the rounding function
seems to be limited.
Thanks for all the help!

P.s. I dont know a lot about macros....

Try this formula provided by Harlan Grove:

=--TEXT(A1,"."&REPT("0",SigDigits)&"E+000")

--ron

 

[joel]

Excel Stores your floating point number using IEE Single point precisio
using 24 binary places. Excel automatically drops the trailing zero
when display the numbers if you use General Format. The solution is t
format the Cells as Numbers with 4 decimal places.

The math is performed exactly the same way no matter how the cell i
formatted, the results is just display differently

 

[Luke M]

There may be a better way, but one way would be to use this formula:

=VALUE(TEXT(A2,"0.000E+00"))

The text function forces XL to use 4 significant digits and then because its
text, the rest of the value is forgotten. The text is then converted back to
a number.

 

[Herbert Seidenberg]

Excel 2007
Engineering and scientific number formats.
Numbers stay numbers, no conversion to text.
Numbers not rounded, just format changes.
Four significant digits displayed, from Meg to Micro.
Macros.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_12_10.xlsm