Numbers iPad

Dan Derby wrote:

Actually, the support for Numbers on Apple Support pales in comparison to the support I had when using Excel.

I suggest and recommend review of the Numbers User Guide for iPad - available both as an online resource and as a download for Apple Books:

Numbers User Guide for iPad - Apple Support

https://books.apple.com/gb/book/numbers-user-guide-for-ipad/id1450570987

Here is another useful resource:

Numbers - Function list - Apple (UK)

Dan Derby wrote:

Actually, the support for Numbers on Apple Support pales in comparison to the support I had when using Excel.

• Numbers help is available within the Numbers application
• If Excel offers the functionality you’re looking for, by all means use it. It’s available for iPad.

Dan Derby wrote:

I’m looking to format a column to take a 10 digit number, add the (xxx) and the dash.

As ChrisJ4203 suggested, that is just what the Contacts app does.

In this example, I literally typed “9876543210” in the “Mobile” field.

And yes, this would automatically dial as well!

And Contacts can be exported using the “Share Contact” button toward the bottom of each contact.

Are you asking about formatting a spreadsheet created by Numbers for phone numbers and Emails, or something else? If you are looking for a way to manage contacts on an iPad? That would be done via the Contacts app, and you can sync contacts across devices via iCloud.

How are you currently managing your contacts? When using the Contacts app, it will provide the formatting you need when you enter the phone number. If you were asking if you could use the Numbers app to create a file, I'm not familiar with using the Numbers app. You can dial from the Contacts app. The Contacts app allows for name, address, email, phone numbers and notes.

You’re telling us how you’re trying to accomplish some objective. Instead, you should tell us what you’re trying to accomplish.