Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format negative figs Julia Excel Discussion (Misc queries) 4 December 2nd 08 03:34 PM
update figs from following 1 Jan after 4th anniversary (2003) Roberta Walker Excel Discussion (Misc queries) 2 July 2nd 08 01:48 PM
percentage/figs on the same graph chedd via OfficeKB.com Charts and Charting in Excel 1 October 31st 07 01:11 PM
I need to math manipulate figs over 10,000( in hrs & min format)? ATECH Excel Discussion (Misc queries) 2 January 27th 06 10:09 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"