Changing Number format

[Wismer]

Hi,

I have cell phone numbers which were originally entered in this format 012-345-6789

I want to change it to (012) 345-6789
I have tried to apply Format>Cell>Special and then Phone Number format but it does not seems to work.

Since I need to apply Vlookup formula on phone numbers, I need to convert the numbers in the same format as I have in other sheet.

Thanks for the help.

Wismer

 

[pgc01]

Hi Wismer

If the numbers you have are really text (including the "-"s) and not just a number formatted, you can try this formula:

=TEXT(SUBSTITUTE(A1,"-",""),"(000) 000-0000")

Hope this helps
PGC

 

[Wismer]

Thank you. Worked Perfect !!!

Peace
Wismer