Forum Discussion
Kyle_S365
Dec 09, 2018Copper Contributor
Problems with formating text within a cell.
how can i change 999-999-9999 to 999999999
Haytham Amairah
Dec 09, 2018Silver Contributor
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