Formula to retrieve last 3 digits of number??
Posted by Kevin on January 07, 2002 8:24 AM
I want to retrieve the last 3 digits of a number from a 14 digit number in column B, into a seperate column C. Can anyone tell me the formula to do this.
Thanks
Posted by Ian Mac on January 07, 2002 8:27 AM
=RIGHT(B1,3) (NT)
Posted by Mark W. on January 07, 2002 8:27 AM
=RIGHT(B1,3) (nt)
Posted by Aladin Akyurek on January 07, 2002 8:28 AM
Kevin --
It's:
=RIGHT(B1,3) [ which gives you a text formatted number ]
or
=RIGHT(B1,3)+0 [ which gives you a true number ]
Aladin
==============
