MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Significant Figures

Posted by Robyn Banks on January 16, 2001 3:40 AM

Can you set Excel to format cells to show only significant figures.
i.e. set to 2 significant figures 2.000 would appear as 2 but 2.006
would appear as 2.001 and 2.100 would appear as 2.1?

Posted by Mark W. on January 16, 2001 7:54 AM

Robyn, I presume that Scientific Notation is out
of the question. Barring that about the closest
I think you'll get is 0.## which unfortunately
produces "2." when 2 is entered.

Posted by Robyn on January 17, 2001 2:20 AM

Excellent! Its a start anyway. If anyone can improve on it I would be glad but its much better than a slap in the face with a wet kipper!

Posted by JDH on January 17, 2001 4:05 AM

I don't agree. I like kippers.