Phone number not showing up as formatted in reports

[perc510]

I formatted a phone number (I think this was done after the numbers were imported into the database) - the format shows up correctly in the table and in forms, but not in a report - not until I edit or change the number, then it shows up correctly in the reports. I have over 3,000 numbers and I would like to find a way to edit the numbers without doing it manually one at a time. I wrote a program in VBA to copy the existing phone number - change the number to null - update the record - and then copy the number back. I still do not have the format in reports, just 10 straight digits. Can anyone help me? Thanks

[TheShabz]

The numbers in the table shouldn't be formatted at all. They should just be 10 digits and nothing more. In the query that is bound to your report, change it to pull:
Format([phoneNumber],"(###)###-####")
instead of just
[phoneNumber]

Formatting like this should be done on the fly. Your table should be used for storing raw data and should not be used for display purposes.