Copy value based on decimal place position

[Bernieg]

I have a variable called USL with a value of 3.36
Trying to split the values as below, no rounding

Thanking you in advance

Bernie

USL = "3.36"

'I only want the digits left of the decimal & the first one after the decimal
'I.E. Pete = 3.3

'I only want the second digit after the decimal
'Pat = 6

 

[Micron]

You're passing a string to USL so you can use string functions like
- Left (where the length to take from the left is found by using Instr to find the decimal point and subtract 1) to get 3, or 33 or 333 or whatever.
- Right (only taking one from the right)
However, if you made a mistake by making USL a string and it should remain a number data type, then ignore that. I think that's important before anyone can provide a precises answer. Your sample data is very limited as well. What if the value is 3.367? You still want the 2nd after the decimal (6) or the last (7) because in your example, 6 is also the last?

 

[Micron]

I've noticed an error in the suggestion. It would return 3 from 3.36 or 33 from 33.6 so would need to be adjusted to include the first character after the dot/decimal. That is a simple matter of adding 1 to the position of the decimal.