Sorry, I should have explained.
"3 significant figures" means that whatever the number,
4 567 000
567.9
2.4678
0.235
only the first 3 significant digits are rounded and displayed:
4 570 000
568
2.47
0.235

I don't want to have to put a ROUND formula in every cell.
I just thought that Excel might have a tool for doing this without having to
put in a formula.

If this isn't possible, maybe someone knows a format that will at least
allow me to control the decimals (limit to 2 or 3 decimal places), and not
put a "." if the number has no decimals.




"HKaplan" wrote:

Give an example of a few original #'s and then how you want them
displayed.