|Technically, the RIGHT, LEFT and MID functions in Excel are Text functions. You should read up on them in the Excel Help files.|
However, since Excel likes to play with numbers more than with text, if it can perform a mathematical operation on a number that was returned by a Text function, it will.
With 6262 in A1, try this:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.