Randomize number

Copper Contributor

So my issue is that i want to move a randomize number like 224, 312, 423 to like a full on phone number like (123) 456-789, (234) 567-891, etc. and change the number in the parentheses like i have one column of randomized number and the other column of the original numbers that i want to change is there a way to do it all at once instead of selecting the cell and changing the number one by one I was told that someone could provide a custom function or something to help me with my issue

 

2 Replies

@Fahadkhan3214 

Display numbers as phone numbers

Excel provides a special number format that lets you format a number as a phone number. For example, you can format a 10-digit number, such as 5555551234, as (555) 555-1234.

 

 

Thxs for what you provided but it isnt what im looking for