How to display results to certain number of significant figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I display results to a fixed number of significant figures?

25100 display as 25000
250 display as 250

25 display as 25.0

2.5 display as 2.50

0.25 display as 0.250

Etc.
 
Simplest way to always display two sig figs is to use scientific
notation: 0.0E+0

If you'd rather have a root canal than use exponential notation, search
the newsgroups for this issue. Several attempts have been made to use
the ROUND and TEXT functions to do what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
How to display 2 pieces of data on one bar of a Pivot Chart? 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
how do I change format for displaying data in cell? 3
Significant Figures 4
how do i show 3 significant figures 1
Format significant digits 6
Column headings display as a numbers 7

Back
Top