Rounding to first non-zero decimal

[nouseforaname1982]

I want to round a decimal number that may have any number of digits so only one non-zero number is shown. For example:

.000123 should equal .0001;
.00003 should equal .00003;
.153 should equal .2;
2.347 should equal 2

I have searched the "rounding" Posts and have not found the answer. Can someone help?

 

[barry houdini]

If your value is in A2 try this formula

=ROUND(A2,INT(1-LOG(A2,10)))

 

[nouseforaname1982]

Thanks,

Clever way of doing it.