I'm working with different numbers which have 6-10 digits, I only want to concentrate on 4 digits of significance. That is, only want to view the left-most 4 digits of the number. The remaining digits should be hidden if they are after the decimal, and replaced with 0 if before.
For example:
123456789 should be displayed as 123400000
0.123456789 should be displayed as 0.1234
0.0001234567 should be displayed as 0.0001234
Instead of using a formula, is this possible using a custom display right in the cell?
Thanks!
For example:
123456789 should be displayed as 123400000
0.123456789 should be displayed as 0.1234
0.0001234567 should be displayed as 0.0001234
Instead of using a formula, is this possible using a custom display right in the cell?
Thanks!