Hi Everyone,

hopefully an easy solution to this;

I want to use the last 3 digist of a referance number in another cell....for example;

I have the number 600003 in a cell and want to referance the last 3 digits in another cell...003, can this be done with a simple command.


Cheers,

Rich.