Aces High Bulletin Board

General Forums => The O' Club => Topic started by: BlckMgk on October 27, 2004, 08:16:14 AM

Title: Need help with excel
Post by: BlckMgk on October 27, 2004, 08:16:14 AM

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

Title: Need help with excel
Post by: Lizking on October 27, 2004, 08:20:42 AM

Format/cell/special/phonenumber

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

Title: Need help with excel
Post by: straffo on October 27, 2004, 08:22:10 AM

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.