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.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
B2 formula copied down :
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 :