Hi,
I would like to be able to pull out different parts of a number. So for example I have the number 0.4675 (they will always be decimal places) and I want to have different cells that show:
0.4
0.06
0.007
0.0005
or even just:
4
6
7
5
What formula allows me to taget a specific digit to the right of the decimal point? (It's possible that the decimal may be infinity). I know I could use something like "=right(left(a1,3),1)" but I thought there may be a better formula for this.
Thanks
Bookmarks