format cells number to 3 significant figures??
Hi,
Is it possible to format cells so that Excel shows the data to 3 significant
figures? (without having to introduce a formula in the cell)
the best I can get is using my custom format
# ##0.###
which isn't exaclty what I'm looking for, and is also annoying because it
always shows the ".", so "100" always displays as "100."
|