How to display results to certain number of significant figures

[Coeliac]

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.

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