|Subject:||Re: display specified significant digits|
|Posted by:||Bernie Deitrick (deit…@consumer.org)|
|Date:||Fri, 10 Oct 2003|
No, not automatically. But you can use a helper column:
will give the value in cell A1 to 3 significant digits.
"JF" <joefan…@hotmail.com> wrote in message
> 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.
> 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
display specified significant digits posted by JF on Fri, 10 Oct 2003