Adding numbers to several cells at one time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi, this may be quite simple but I can't seem to figure it out. Please help

I have a list (Column) of phone numbers in the XXX-XXXX format. I'd like to
add the Area code (which is the same for them all) and make this list display
in the XXX-XXX-XXXX

Any help? Thanks
--
Bob
.

Relevant Pages

  • Re: quick question
    ... > I'd like to validate an input my from user i.e. make sure that the user ... > XXX-XXXX ... > difficulty wrapping my head around it. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • change format for phone numbers automatically
    ... I have a worksheet with phone numbers in a column. ... xxx-xxxx some are xxx-xxx-xxxx they all need to be ... -- Zig Ziglar ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • quick question
    ... I'd like to validate an input my from user i.e. make sure that the user ... enters the phone number is the following formats ... XXX-XXXX ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)