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

 

[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