Problems with formating text within a cell.

Hi,

The solution depends on the datatype of the number (999-999-9999) in the cell.

If it's a text string, which means that the dashes are really part of it, then you can use the formula suggested by Damien_Rosario to remove them.

But if these dashes are just a format to this number, you can go to the Format Cell (Ctrl+1) to change the format to General or Number.

Hope that helps