How to display results to certain number of significant figures
 

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.

How to display results to certain number of significant figures
 

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.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=499635