Re: display specified significant digits

Giganews Newsgroups
Subject: Re: display specified significant digits
Posted by:  Bernie Deitrick (deit…@consumer.org)
Date: Fri, 10 Oct 2003

JF,

No, not automatically.  But you can use a helper column:

=ROUND(A1,2-INT(LOG(A1)))

will give the value in cell A1 to 3 significant digits.

HTH,
Bernie

"JF" <joefan…@hotmail.com> wrote in message
news:026d01c38f5c$3b4ab1e0$a30128…@phx.gbl...
> Can Excel be told to display "n" significant digits
> automatically, without formatting each cell manually.
>
> For example, a column of 4 numbers formatted to 3 sig.
> digits:
>
> 1.234567 would format to 1.23
> .0234321 would format to .0234
> 123.023 would format to 123.
> 23.123456789 would format to 23.1
>
> thanks

Replies

None

In response to

display specified significant digits posted by JF on Fri, 10 Oct 2003