custom format for phone numbers - Page 2
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: custom format for phone numbers

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    On 2002-03-13 07:43, Anonymous wrote:
    Sorry for the confusion, they are three different numbers, showing if somebody enters a local number (2222222), area code and number(1232222222), or 1 area code and number(11232222222)
    Ahhh, sorry for being so literal. Try this...

    [<=9999999]###-####;[>10000000000]#-###-###-####;###-###-####

  2. #12
    Guest

    Default

    Mark, tried that I get Excel cannot use the number format you typed, I retyped it 3 times to make sure, BTW I am using '97 if this matters

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-13 08:46, Anonymous wrote:
    Mark, tried that I get Excel cannot use the number format you typed, I retyped it 3 times to make sure, BTW I am using '97 if this matters
    I copied it from the input field. Try pasting it.

    [ This Message was edited by: Mark W. on 2002-03-13 11:12 ]

  4. #14
    Guest

    Default

      
    Ok that works, I was trying to right click and paste works with control V, Thanks

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com