#1   Report Post  
Rashed
 
Posts: n/a
Default Format

How can I format 2392617177 to 239-261-7177? Please help
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help



  #3   Report Post  
Rashed
 
Posts: n/a
Default

I tried to follow but it didnt work. I have large quantity data in this
format 2392617177, I would like to put in this format 239-261-7177. How can I
do it? Thanks

"Don Guillett" wrote:

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help




  #4   Report Post  
Rashed
 
Posts: n/a
Default

Thanks...it work.........thank you very much. It save my lots of time. Thank
you Don Guillett.

"Don Guillett" wrote:

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help




Reply
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
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM
How to format a date to a different format Laura Excel Discussion (Misc queries) 1 March 5th 05 09:59 PM
protecting format Esmerelda Excel Discussion (Misc queries) 1 February 25th 05 12:53 PM


All times are GMT +1. The time now is 07:09 PM.

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

About Us

"It's about Microsoft Excel"