Need help with excel

[BlckMgk]

I have a column"Phone" formated:

0123456789

i need to format it to:
(012) 345-6789

I can do it using an SQL based program

"(" + substr(Phone,1,3,) + ") "+ substr(Phone,4,3)+"-" +substr(Phone,7,3)

But don't have a clue with Excel

Suggestions?
_____

And another question... I inserted 3 columns to the end of the file, and when I do a "SAVE AS" to a dbaseIV file it eliminates the last 3 columns I just inserted.

Please I need help with this folks.

Thanks
-BM

[Lizking]

Format/cell/special/phonenumber

edit-for the last question, change the printable area, it sounds like.

[straffo]

Right click on the cell ,select the format menuitem, select custom format  paste this in the edit box :
(000) 000-0000

for your last question check if your column name is less or equal to 8 char length.