This couldn't be easier in Crystal. Honestly. It's nuts. Anyone who has struggled with any kind of explicit conversion in TSQL or programming languages will appreciate this.
Within a formula, convert to text by using the TOTEXT() function.
This will allow you to use String functions (i.e. Mid, Left, etc) on any Numeric field.
This changes not only the formatting of the output but the underlying Crystal object data type.Try it and have fun!