How to display results to certain number of significant figures

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.
 
M

MrShorty

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

Significant Figures 4
how do i show 3 significant figures 1
How to display 2 pieces of data on one bar of a Pivot Chart? 1
Multi-demensional frequency distribution 4
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
How to display figures with thousand omitted 3
Number of significant digits allowed in a cell is 15. 2
Format significant digits 6

Top