You can use the right function to return the right most characters (12?).  Example: Right({String}, 12).  If you ever have a string that is not a fixed length, then you can use len to determine the lenght of the string first.  Example:  right({String}, len({String}) - 3).

Edited by kevlray - 15 Jun 2010 at 4:21am

I tried doing this and I get an error stating a string is required and last I checked it is a field name and I have that. Am missing something else?

Right({DriveMaster.DriveID},4)

It is. Got past that. Now I need to get rid of the comma.

if for some reason you chose to convert it to text you can format it during the conversion but as Kevlray indicates there are easy formatting options while keeping it numeric.

Edited by DBlank - 11 Feb 2015 at 7:55am