LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Making sure users enter phone numbers in a particular format


Just a caution on trying to make things too tight. Just looking at the
format of telephone numbers I have - all of which are valid :

USA
+1 212 111 1111
01 212 111 1111

UK
01411 123456
+44 (0) 411 123456
0207 123 1234
0044 411 123456


France
0033 5 11 22 33 44
+33 5 11 22 33 44
05 11 22 33 44

Singapore
0 1234 5678


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=509591

 
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
format for phone numbers? Pfabeo Excel Worksheet Functions 1 August 10th 09 02:56 PM
format phone numbers with an 800 Wanna Learn Excel Discussion (Misc queries) 2 May 5th 09 06:39 PM
Format phone numbers to look the same Access Joe Excel Discussion (Misc queries) 2 April 30th 08 04:26 PM
How do I format phone numbers in excel? CBickley Excel Discussion (Misc queries) 11 August 23rd 06 11:24 PM
Format sequence for phone numbers? LACA Excel Discussion (Misc queries) 2 June 1st 06 01:44 AM


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