Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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 ?
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
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
Thats fixed it,, thanks,
format Australian phone number with leading zero
