I am trying to format a phone number column in a DataGridView control with no success. First I tried setting the DefaultCellStyle in the column properties to "(###) ###-####" (both with and without the quotes) but that did not work. Then I tried setting the value programmatically using the following line of code, but that also did not work:

PersonnelPhoneNumberDataGridView.Columns("PersonnelPhoneNumber").DefaultCellStyle.Format = "(###) ###-####"

Finally I tried to set the property in the CellFormatting event for the column usinga similarline of code and that also did not work. I have run out of ideas to try, so any help would be appreciated.