The OP didn't want 3 decimal places (123.456), he wanted 3 significant
figures (0.456 or 123 or 3.46).
--
David Biddulph

"FSt1" wrote in message
...
hi
what's wrong with formatting it to Number with 3 decimals places?
or did i miss somthing?

regards
FSt1

"wb198" wrote:

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."