Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UK Phone Numbers (2000)

    Hey there ... Is there any way of making customizing a cell to format UK phone numbers.
    I would want the number to look like this:
    0 207 255 6255

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UK Phone Numbers (2000)

    Enter the phone number as a number (without spaces). Don't worry that the leading zero disappears. Select Format | Cells..., activate the Number tab, select the Custom category and enter 0 000 000 0000 in the Type box. Click OK.

    Or just enter the phone number the way you want it to be displayed. It will be interpreted as text.

Posting Permissions

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