You will have to enter this formula in another cell ( B1, say) and pull down as needed
When you have the results - Copy Paste Special - Values to the place you want

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Would another way out of this be to set up a custom number format. Set the format as 000-000-0000.

Regards

Tony