![]() Then, click OK button, and now, the new phone number format has been applied to the numbers, see screenshot: And then, select the pasted cells, press Ctrl + 1 keys to open the Format Cells dialog box, in this dialog, under the Number tab, select Custom option from the left Category pane, and then type the phone number formatting as you need into the Type text box, in this example, I will enter this format: (#) #-#, see screenshot:ĥ. ![]() Then, please copy the formula cells and paste them into another location as values.Ĥ. ![]() Then, drag the fill handle down to the cells where to apply this formula, and all the phone number formatting has been cleaned up immediately, see screenshot:ģ.
0 Comments
Leave a Reply. |