Excel cell number formatting should have a significant digits opti

G

Guest

One should be able to format a cell in Excel so that the number of
significant digits stays constant, no matter how the digits or decimal places
change. You get something like this with the "Scientific" number format, but
it's not as intuitive to look at.
 
M

Myrna Larson

Maybe, but it won't happen in any current version of Excel. It's a business
app. How many business folks do you think understand the concept of
significant digits?


On Tue, 26 Oct 2004 14:07:01 -0700, Sleep Scientist <Sleep
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel cell number formatting should have a significant digits opt. 1
Format for Significant Digits 3
Number of significant digits allowed in a cell is 15. 2
How do I prevent the cell from changing the number I enter? 2
Showing 18 digits or more in a cell 1
including non-significant digits (XP) 2
formatting a cell 2
I cannot enter a number containing more than 15 digits in Excel 1

Top