LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bob
 
Posts: n/a
Default Adding numbers to several cells at one time

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get Excel to stop formatting time cells incorrectly Chuck Cusack Excel Discussion (Misc queries) 2 August 6th 05 01:10 AM
Cells formated as numbers are calculating like text MM_BAM Excel Discussion (Misc queries) 4 July 7th 05 01:29 AM
adding cells with text and numbers Tat Excel Discussion (Misc queries) 1 June 22nd 05 03:01 AM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Finding Numbers with Cells that also contain letters Adam Excel Discussion (Misc queries) 7 December 29th 04 02:41 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"