On my report, I have the field phone number, which is 11 characters.
I want to format the field on the report so that it is displayed:
9-999-999-9999. But when I try to do it in the format box in the report designer, the dashes replace the corresponding digits. How can I format it so it displays the way I want it to?

Thanks,
Ryan