You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.