Hopefully a simple one, I have a number, say 1234567.890
this number could be anything but will be this length.
How do I truncate the first 3 numbers so it turns into 4567.890
?
This could be any number so subtracting 123000 will not work.
I'm working with map data in UTM coordinates (but that should not matter)
Example
x = 580992.528
y = 4275267.719
For x, I want 992.528
For y, I want 267.719
Note: y has an extra digit to the left of the decimal so 4 need removing