Phone number formatting

[cpg84]

I want to enter in a cell, the following number:

0123456789

and I want it to appear as:

(01) 2345 6789

Also, in a different column, I want to enter the following mobile number:

0412345678

and I want it to appear as:

04 1234 5678

Anyone know how to do either or both of these?

 

[ericlim1963]

you may use control 1 to format

steps

control1
select custom
then go to type and key in (00) 0000 0000
or 00 0000 0000

you will see the format