Thread: Sig Figs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alterac Alterac is offline
external usenet poster
 
Posts: 1
Default 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....