Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

format Australian phone number with leading zero

I've seen this question asked and read some replies and even watched some videos, but solutions using cell formatting still not working the way I expect it to. I want to format cells to show Australian mobile phone numbers with format of 0### ### ###. The leading zero is always there, but won't show.

What am I doing wrong ?

Posted on Mar 22, 2022 10:34 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 23, 2022 12:18 AM

TurkeyBaster wrote:

I want to format cells to show Australian mobile phone numbers with format of 0### ### ###. The leading zero is always there, but won't show.


I think you're really close!


Does this do what you want?




SG

2 replies

format Australian phone number with leading zero

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.