In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?

In Excel 2016 I need to show zeros out to the leading non-zero digits and then just the two digits after that. For example:

and so forth.

2 Answers

If rounding is required, you can also try this formula =ROUND(A1,INT(2-LOG(A1))).

Try,

In B2 formula copied down :

=0+LEFT(A2,MIN(FIND({1,2,3,4,5,6,7,8,9},A2&1/17))+1)

Edit :

1] 1/17 =0.0588235294117647 which is called Pandigital number that contains digits from 0 to 9

2] A2&1/17 is a short form of A2&1234567890 in which to shorten the formula length.

3] Other Pandigital number can also be used :

A2&5^19

A2&7^18

A2&3^45

..........