Hi Clay,
I have a similar situation. But I can't change the field type in SP to text because it is being used for calculations. Further, my field is a text field, but it is a drop-down list box. When the field was not a drop-down list box, I used the substring function to format, but this does not work ...