display specified significant digits

Giganews Newsgroups
Subject: display specified significant digits
Posted by:  JF (joefan…@hotmail.com)
Date: Fri, 10 Oct 2003

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