On Fri, 18 Jan 2008 07:06:01 -0800, wb198
wrote:

Hi,

Is it possible to format cells so that Excel shows the data to 3 significant
figures? (without having to introduce a formula in the cell)
the best I can get is using my custom format
# ##0.###

which isn't exaclty what I'm looking for, and is also annoying because it
always shows the ".", so "100" always displays as "100."

In Excel, "format" usually refers to changing the display without changing the
underlying value.

That being the case, I don't believe you can, other than by using the
Scientific format as pointed out by others.


--ron