LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Frank @ St. Louis
 
Posts: n/a
Default How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx

I am combining three databases on Xcel. Total of 18,000 items/contacts.
Approximately 5,000 show a phone number of "xxxxxxxxxx" which will be
incompatable with the remaining items/contacts that have the phone number
listed as "xxx-xxx-xxxx". I like the latter format. How do I change the
list of 5,000 to "xxx-xxx-xxxx"? I have Excel 2002

Simple question, but I am stuck.

Thanks for your help.

Frank
 
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 can I change Numbers in WOrds in Excel A J Excel Discussion (Misc queries) 3 May 9th 05 08:14 AM
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
Random Numbers Change? Les Coover Excel Worksheet Functions 2 December 17th 04 02:49 AM
Phone Numbers natei6 Excel Worksheet Functions 6 November 25th 04 02:38 AM


All times are GMT +1. The time now is 10:47 AM.

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"