extract the 1st 2nd 3rd etc value of a number
I have a number that has 4 places to the right of decimal example: 98765.4321
I am trying to extract each position from the right into a field
So i have a field ready for each position
1 =1 2=2 3=3 4=4 5=. 6=7 7=8 etc etc
I tried right but it is picking up x-number of characters...but I only need the 1 character/value from each.
I thought this would work but it is doing the same as Right.
RightValues ( Right ( MyField ; 1 ) ; 1 )