As mentioned, when using the Format options in Crystal, it can only be as smart as the underlying field. That is, a number must be a "Number" and text must be "Text". If you aren't seeing the expected formatting options, you may need to convert the data type of the underlying database column.
There are many functions available in Crystal to make this happen, but for now we'll keep it simple.
1. To convert from Text to Numeric, simply use the ToNumber() function within a formula, like this;
The resulting formula will "behave" like a number.
2. To convert from Numeric to Text, use the ToText() function;
Try it. Every Crystal Reporter should be comfortable with type conversion; it's our bread and butter!