Posted by Fred Berry on January 02, 2002 11:14 AM
I have a spreadsheet set up that has phone numbers and zip codes. Can anyone tell me how I can get these numbers to display in a standard format. They currently display as a continuous strand(ie 0000000000). I would like them to display as 000-000-0000(phone) or 00000-0000(zip). If possible I would like to format them without having to manually enter the hyphens for each number. I have tried a customized format and could not get it to work. Thanks for your help.