Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sig Figs
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 figs since the rounding function seems to be limited. Thanks for all the help! P.s. I dont know a lot about macros.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format negative figs | Excel Discussion (Misc queries) | |||
update figs from following 1 Jan after 4th anniversary (2003) | Excel Discussion (Misc queries) | |||
percentage/figs on the same graph | Charts and Charting in Excel | |||
I need to math manipulate figs over 10,000( in hrs & min format)? | Excel Discussion (Misc queries) |