LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
frustratedagain
 
Posts: n/a
Default how do I add phone number format as a permanent custom format?


Every Excel spreadsheet I receive includes column(s) somewhere of phone
numbers. Rather than have to recreate in EACH file a new custom format
I dream of being able to PERMANENTLY add two telephone
number formats so that I can EASILY apply the following formats:
###-###-#### and ###-###-#### ###. Is there any way on EARTH that I
can PERMANENTLY add these formats to MS's available formats?


Remember: I DO NOT CREATE new Excel spreadsheets, I only receive them,
so templates would be useless.

frustrated...


--
frustratedagain
------------------------------------------------------------------------
frustratedagain's Profile: http://www.excelforum.com/member.php...o&userid=30997
View this thread: http://www.excelforum.com/showthread...hreadid=506639

 
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
Time format to number while keeping value Jim Excel Worksheet Functions 2 January 12th 06 05:45 PM
Format Number to Text Roni Excel Worksheet Functions 2 May 17th 05 03:17 PM
Format Number (custom) barryderay Excel Discussion (Misc queries) 3 April 7th 05 07:30 PM
Number Format (custom) barryderay Excel Discussion (Misc queries) 2 April 7th 05 07:24 PM
Custom Number Format for Weight Tom Excel Discussion (Misc queries) 3 February 27th 05 02:15 PM


All times are GMT +1. The time now is 06:40 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"