View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default significant digits

Is there a format available to display significant digits? If you have the
following data:
0.99
1.0
1.1
1.11
is there a format you can use to display say 2 significant digits for the
entire data set? Two significant digit display would be:
1.0
1.0
1.1
1.1

Is there a formula that will use only X significant digits in the calculation?

We are required to report to regulatory agencies using significant digits
rather than decimal places.
Thanks!