LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default validate phone number

hi,

how can i make sure the user enters a phone number.

i know u can go to formatcellsgeneral and select
specialphone number

BUT.. this only formats it to a phone number. how do I
ensure the user enters in only 10 digits?? and then also
put it in the nice 'phone number' format (###) ###-####

Help! :)
 
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
Phone number not nrodADAA Excel Discussion (Misc queries) 2 September 4th 07 09:42 PM
Validate Whole Number Series with Exclusions QLT1120 Excel Discussion (Misc queries) 2 September 18th 06 07:41 PM
validate phone numbers etc. John New Users to Excel 1 July 11th 06 02:36 AM
? Link attached - How to validate SIN (Social Insurance Number) [email protected] Excel Worksheet Functions 5 December 17th 05 07:07 AM
Phone number Lisa Excel Discussion (Misc queries) 3 May 10th 05 10:34 PM


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